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.

The SitePoint Forums have moved.

User Tag List

Thread: Duplicate Entries

Thread Tools

Display

Duplicate Entries

Bookmarks

Bookmarks

Posting Permissions