Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting 2 db entries per submission

Status
Not open for further replies.

mumzer

Programmer
Sep 13, 2002
3
US
I have written a survey in ASP using javascript and the answers are dumped into an MS Access 2000 database. Whenever I press the submit button on the form, 2 almost duplicate records are recorded to the database. The only reason they are not duplicates is because I have an autonumber field as PK. So each individual record has a unique number, but all the data fields are the same in each record. Does anyone know why this is happening and/or how to fix it? My connection string:

Code:
conn= Server.CreateObject("ADODB.Connection")
conn.Open(Application("CONN_STR")="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=//server/folder/folder/db.mdb")

 mysql = "sql statement";

conn.Execute(mysql);
conn.Close();
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top