I have had this same problem. I usually make check for more than one field
though. Some users might share the same email address, therefore, if one
registered, none of the others would be able to. I usually check for
lastname and email. Good luck!
----- Original Message -----
From: Duane Boudreau <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, May 10, 2000 11:09 AM
Subject: RE: Double Entries?? How to stop??
> 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.
>
------------------------------------------------------------------------------
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.
