In our most recent app we addressed that problem.
In the form that submits the data we stored a hidden field which contained the record
count before insertion. If the recordcount was correct, it inserted, otherwise it
didn't.
Beats asking the user to be nice... ;)
David Cummins
Ubiquity Software Ltd.
Grady Milhon wrote:
> I had the same problem when people were clicking the submit button twice before
> the page was loaded. I resolved it by just saying Please click only once.
>
> Grady
> [EMAIL PROTECTED]
>
> -----Original Message-----
> From: [EMAIL PROTECTED] at INTERNET
> Sent: Wednesday, May 10, 2000 10:36 AM
> To: [EMAIL PROTECTED] at INTERNET
> Subject: Double Entries?? How to stop??
>
> Hi Everyone,
>
> I have a form that collects registration info and then inserts to a
> database.
>
> We seem to be getting quite a few double entries. I can't figure out how
> these double entries are created. Some are where people go back and resubmit
> to correct errors, but most doubles are exactly the same records.
>
> Any idea what causes this?? Is there a way to prevent this???
>
> Thanks,
>
> Jeff Fongemie
>
> ------------------------------------------------------------------------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=l
> ists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubs
> cribe' in the body.
> ------------------------------------------------------------------------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
