PC Review


Reply
Thread Tools Rate Thread

ASP.Net Duplicating DB Entries

 
 
Todd Plambeck
Guest
Posts: n/a
 
      5th Aug 2005
I have an ASP.net order entry system that will occasionally insert duplcate
orders into the database. We are using SQL Server for the session state.
This also only seems to happen when the server has not been rebooted for a
long period of time. When it starts duplicating, it will do so about 3 or 4
times and it's not every order. Some will come in fine the next one gets
duped, the next couple are fine, then another dupe or two, etc. Anyone have
any ideas why this might be happening?

Thanks,

Todd


 
Reply With Quote
 
 
 
 
=?Utf-8?B?QnJhZCBSb2JlcnRz?=
Guest
Posts: n/a
 
      5th Aug 2005
Have you considered the possible effect of a double-click? Depending on your
design it may be a possibility.

"Todd Plambeck" wrote:

> I have an ASP.net order entry system that will occasionally insert duplcate
> orders into the database. We are using SQL Server for the session state.
> This also only seems to happen when the server has not been rebooted for a
> long period of time. When it starts duplicating, it will do so about 3 or 4
> times and it's not every order. Some will come in fine the next one gets
> duped, the next couple are fine, then another dupe or two, etc. Anyone have
> any ideas why this might be happening?
>
> Thanks,
>
> Todd
>
>
>

 
Reply With Quote
 
WJ
Guest
Posts: n/a
 
      5th Aug 2005
"Todd Plambeck" <(E-Mail Removed)> wrote in message
news:%233$(E-Mail Removed)...
>I have an ASP.net order entry system that will occasionally insert duplcate
>orders into the database.


The only thing to prevent duplicate data record is to designate a field
within the Order table as Primary Key/Unique and not null. Then trap the
insert command to see who causes that !

> We are using SQL Server for the session state.


This should be fine. I am using this too and found out that it is very
reliable. Performance is not that bad!

John


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicating Entries =?Utf-8?B?TWFydGlu?= Microsoft Outlook 1 5th May 2006 07:54 PM
HELP: Duplicating Entries =?Utf-8?B?VGlt?= Microsoft Access 12 1st Feb 2005 09:15 PM
Duplicating entries =?Utf-8?B?VGlt?= Microsoft Access 0 10th Jan 2005 01:45 PM
How to avoid duplicating entries, etc. Paul Microsoft Excel Worksheet Functions 2 21st Aug 2003 12:14 PM
Re: Duplicating Query Entries Melinda Microsoft Access Queries 3 21st Jul 2003 02:23 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:31 AM.