Duplicate Entries

[SSJ]

Hello Everyone,

I have a problem with Insert statement.
Though My SQL Statement executed once only, there are 2 records entered in DB.

I am using ASP and SQL Server.

Does anybody know the solution?

[siteguru]

Without seeing the code and understanding the DB structure? No.

[SSJ]

Sql Query Is As Follow:

logSQLQuery = "INSERT INTO ActivityLog (ActivityLogGUID, ActivityGUID, UserGUID, AnswerFlag) VALUES('" & ActivityLogGUID & "', '" & ActivityGUID & "', '" & Session("UserGUID") & "', " & Answer & ")"
Conn.Execute(logSQlQuery)

DB:
Table Name:ActivityLog

Columns:
ActivityLogGUID guid unique
ActivityGUID guid unique
UserGUID guid unique
AnswerFlag flag

Hope this will make sense to you...

[siteguru]

Are any of those fields set as AutoNumber/AutoIncrement?

What happens if you try an equivalent hard-coded query in the MS SQL query manager?

[SSJ]

Thanks for you kind response.

No fields are set to AutoNumber/AutoIncrement.

Following is the structure of my table.

Field Type
-----------------------------------------------
ActivityLogGUID uniqueIdentifier
ActivityDateTime getNow() - default value
ActivityGUID uniqueIdentifier
UserGUID uniqueIdentifier
AnswerFlag Bit


If I am entering query through Query Manager, only 1 record is entered.

[jimfraser]

If this action is being initiated by a <form>, make sure you are not submitting it twice (check any validation javascript)

[SSJ]

No I have checked again that.
Form is submitting once only.
I have apply following trick also to check whether query is executed more than once.

logSQLQuery = "INSERT INTO ActivityLog (ActivityLogGUID, ActivityGUID, UserGUID, AnswerFlag) VALUES('" & ActivityLogGUID & "', '" & ActivityGUID & "', '" & Session("UserGUID") & "', " & Answer & ")"

Conn.Execute logSQLQuery
Response.write logSQLQuery
Response.End

Query is printed only once but in database there are 2 records are inserted.
So I am sure there is a problem with execution of Insert Query.

Is this a SQL Bug?

[jimfraser]

Is this a SQL Bug?

No

Post the entire ASP page and the page that contains the form you are submitting.

[SSJ]

Hi Jim,

May I mail you the pages?

[jimfraser]

PM me them please

[SSJ]

Jim,

I am not able to attach the code im PM as code are so long and PM allow only 8192 characters.

[SSJ]

Anybody have a chance to look at this??

[siteguru]

How about save the .asp page as .txt, upload it to your site, then PM us with the link or post the link here?

[SSJ]

Siteguru,
May I mail you?

[siteguru]

No. Just post a link or PM it.

[SSJ]

I don't have a live site working currently and PM allow only 8192 characters.
That's why I am asking you to mail?

[DaveMaxwell]

Just save it as a text file and post it in this thread as an attachment. That way everyone can get in on the conversation.

[SSJ]

Thanks Dave.
I never seen this option as I am using Quick Reply always.
I will post the code soon...

[SSJ]

Both the pages are attached here...

Please help..

[DaveMaxwell]

Hmmm. Nothing's jumping out that's glaringly wrong. the only thing I would think to try would be to get rid of the extraneous recordsets on the inserts

So
Set AnswerRS = Conn.Execute(SQLQuery)
Becomes
Conn.Execute SQLQuery

But that is only a performance saving - that shouldn't cause two hits to that insert statement.

Are you getting dups on every insert, or just that one table?

[SSJ]

Set AnswerRS = Conn.Execute(SQLQuery)
Becomes
Conn.Execute SQLQuery

I have tried this one previously but no luck...

[SSJ]

Are you getting dups on every insert, or just that one table?

No. I have another 30-40 pages and many insert queries but they are running superbly.

I am getting this duplicate when queries submitted to this page only...

[DaveMaxwell]

OK, but are the dups only to the ActivityLog table, or are you getting dups on the ActivityAnswers and ActivityMessages tables as well?

[jimfraser]

There's a lot of javascript on that page, an ajax form submit function and a real form submit function, are you sure they're not both being called?

[SSJ]

OK, but are the dups only to the ActivityLog table, or are you getting dups on the ActivityAnswers and ActivityMessages tables as well?

Yes I am getting in all the tables.
I just can't guess the regularity of duplicates.

Sometimes duplicates are there in ActivityLog table, sometimes in ActivityAnswers and sometimes in ActivityMessages table.