I have searched the forum and tried a solution that was posted but I had no success. This code is meant to add new record to a database. When I run the code I get 2 records of the same record.

Any help that can be provided would be great!


here is my code....

<%

strconn = "Provider=Microsoft.Jet.OLEDB.4.0; " _
& "Data Source=E:\Webspace\resadmin\ed\tellop.mdb"

strSQL = "INSERT INTO Purchase_Order_Line_Items(PurchaseOrderNumber,Part Number,Quantity,UnitPrice)Values('" & Request.Form("T1") & "','" & Request.Form("T2") & "','" & Request.Form("T3") & "','" & Request.Form("T4") & "')"

set conn = Server.CreateObject("ADODB.Connection")
conn.open strconn

conn.execute(strSQL)
conn.close
set conn = nothing




%>

Hi,
I also faced the same problem.
In your code the page must be submitted twice check in your code.

Thanks

You must be using an image for submitting the form
<input type = image .....> and defined an on-click event that agains submits the form. This way two records are being inserted.

Thank you so much, I never even thought to go look at the form that was passing the data!!! You are awesome.

Thank you so much, I never even thought to go look at the form that was passing the data!!! You are awesome.

lol @ u "Bobby-2-times"