Make sure that you eliminate any case-sensitivity when doing your query
like this: where lower(email_addr) = lower('#form.email_addr#')
When inserting emails, I also suggest you insert them trimmed (the trim
() function)
In <[EMAIL PROTECTED]>, Duane Boudreau
([EMAIL PROTECTED]) in a fit of unbridled passion, wrote:
> 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.
