The only way to prevent double entries is to perform a "duplicate check"
query before any insert.
<cfquery name="dupCheck" datasource="#dsn#">
SELECT ID
FROM Table
WHERE IdentifyingValue1 = '#FORM.identifyingValue1#'
AND identifyingValue2 = '#FORM.indentifyingValue2#'
</cfquery>
<cfif NOT dupcheck.recordcount>
<!--- perform insert --->
</cfif>
Sharon
At 10:38 AM 5/10/2000 -0700, Josh Black wrote:
>I've had this problem too.....My guess is that people are double clicking
>the form submit button. I've attempted to remedy this situation with
>something like the following:
>
><input type="submit" name="whatever" value="Submit" ondblclick="return
>false;">
>
>but it doesn't appear to work. I would be interested to know if there's any
>way to do this so it works. Thanks.
>
>Josh
>-----
>"You can't help that...we're ALL mad here." -- Cheshire Cat
>
>----- Original Message -----
>From: "Jeff Fongemie" <[EMAIL PROTECTED]>
>To: "Cf-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, May 10, 2000 8:36 AM
>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=listsbody=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=listsbody=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.
