This topic is locked

Duplicate records inserted

5/24/2007 10:49:30 PM
ASPRunnerPro General questions
J
jawendell author

I use the following code in a after successful login event:
Sub AfterSuccessfulLogin()

'** Insert a record into another table ****

strSQLInsert = "insert into Tracking (Username, Updated) values ('" & Session("UserID") & "', now())"

dbConnection.Execute strSQLInsert
End Sub
It is pretty straight forward, but sometimes the record is inserted into the table twice. What am I doing wrong?
Thanks,
Jerome A. Wendell

Sergey Kornilov admin 5/25/2007

Jerome,
if you can reproduce this issue post yopur application to Demo Account and shoot me an email with URL and steps on reproducing this.

J
jawendell author 5/25/2007

Sergey,
Since I finalized my application, I have not been seeing this issue. The application is about to go into production, so I will be able to watch for the problem. If it occurs, I will get back to you.
Thanks for all of your help.
Jerome