Jeff,
Try making their email address a unique field and always query the database
for the email address being submitted before inserting. If it already exists
give your user a warning and don't do the insert.
-----Original Message-----
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 10, 2000 11: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.
