Duplicate Entries

**SSJ** · Feb 27, 2007, 05:34

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** · Feb 27, 2007, 05:40

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

**SSJ** · Feb 27, 2007, 06:05

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** · Feb 27, 2007, 09:12

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** · Feb 27, 2007, 22:56

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** · Feb 28, 2007, 08:44

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

**SSJ** · Feb 28, 2007, 22:58

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.

Code:

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** · Mar 1, 2007, 09:09

Is this a SQL Bug?

No

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

**SSJ** · Mar 1, 2007, 23:24

Hi Jim,

May I mail you the pages?

**jimfraser** · Mar 2, 2007, 13:22

PM me them please

**SSJ** · Mar 2, 2007, 23:11

Jim,

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

**SSJ** · Mar 9, 2007, 04:08

Anybody have a chance to look at this??

**siteguru** · Mar 9, 2007, 07:43

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** · Mar 9, 2007, 22:52

Siteguru,
May I mail you?

**siteguru** · Mar 10, 2007, 06:21

No. Just post a link or PM it.

**SSJ** · Mar 11, 2007, 22:27

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** · Mar 14, 2007, 08:26

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** · Mar 15, 2007, 00:05

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

**SSJ** · Mar 15, 2007, 00:06

Both the pages are attached here...

Please help..

**DaveMaxwell** · Mar 15, 2007, 05:31

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** · Mar 15, 2007, 06:34

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

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

**SSJ** · Mar 15, 2007, 06:36

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** · Mar 15, 2007, 07:13

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

**jimfraser** · Mar 15, 2007, 08:42

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** · Mar 15, 2007, 23:21

Originally Posted by DaveMaxwell

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.

User Tag List

Thread: Duplicate Entries

Thread Tools

Display

Duplicate Entries

Bookmarks

Bookmarks

Posting Permissions