Jeff:
use a hidden form field with a good sized random number, this number is
inserted into a field in your table (need to add a new field). Prior to
doing an insert check for the existance of the hidden fields value in the
database, if it exists you have a resubmittal and can abort the insert. This
works better than using straight form field values (like an email address)
which can possibly repeat in the data without being a resubmittal.
hth
Matt
-----Original Message-----
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 10, 2000 9:36 AM
To: Cf-Talk
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=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.
