Why duplicate record can exists?
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=1593
Printed Date: 28 March 2026 at 11:07pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Why duplicate record can exists?
Posted By: ngaisteve1
Subject: Why duplicate record can exists?
Date Posted: 04 April 2003 at 2:38am
|
Just want to ask why duplicate record can happen. I mean even I click the submit button once, it can still be duplicated and sometimes it happen and sometimes not. Is it the database problem? Thanks for answering. |
Replies:
Posted By: MadDog
Date Posted: 04 April 2003 at 2:45am
|
Is this your app doing it or what? If its making duplicate records then your probably clicking submit twice or your refreshing your page or your adding it twice in the SQL statement. ------------- http://www.iportalx.net" rel="nofollow"> 
|
Posted By: ngaisteve1
Date Posted: 06 April 2003 at 6:57pm
| I didn't submit it twice nor refresh it nor adding it twice in sql. Some said that it is because of the javascript method onclick(). I'm still looking for more possibilities. Anyway, thanks. |
Posted By: Bluefrog
Date Posted: 09 April 2003 at 7:55am
|
I encountered a bizarre situation that may be similar... it didn't have to do with inserts, just with selects. With a specific record (i.e. ONE (1) specific record - always) that existed in the DB (MS SQL Server) only once. When it was output, it would appear twice... I was too damn lazy to find out why though...
|
Posted By: Badaboem
Date Posted: 09 April 2003 at 8:40am
|
Here's another one..if you created the database yourself it could be that you didn't auto number the fields, or records. ------------- http://www.c4dportal.com"> 
|