Adding Duplicate Record in database

[raaaz]

Hi All,

I am having a totaly different sort of problem which is out of my efforts now so may be any one out of you might help me out of this.

I am using very simple code below to add a record in database and it is working, i mean record is being inserted in database
---------------------------------

<!--#include file='../include/connection.asp'-->
sql = "insert into tblbuilding (building_name,area_name,city_name,description,lib _status,dated,timed,logby) values ('" & Request.Form("buildingname") &"','" & request.Form("areaname") &"','" & request.Form("cityname") & "','" & descr & "','1','" & date() &"','" & time() & "','" & session("uname")& "')"

conn.execute sql
Msg = "1 Record Added ....... "
Response.redirect ("buildingsnaps.asp?ConfMsg="&Msg)

----------------------------

But the problem is that when this page execute and when page redirect to next page showing the values from same table where i am adding records, but it shows me double enteries with different id. There is no loop in above code but in my point of view page is being executed twice which cause double entry in database but i cant understand how this all is happening...

Kindly respond me soon to get out of this problem...

[shweta123]

Hi,

Hope so you still need this,

Try to debug the code by not redirecting the page "buildingsnaps.asp". Are you doing something on this page because which record is getting inserted twice?

Also, check if you are submitting the page more than once by mistake.