The method I have always used to get around this is to do a check
against the DB to see if another entry in the DB has the same values.
The number of values that you check will depend on how many you need to
guarantee uniqueness.
Here's an example:
<CFQUERY NAME="CheckDB" DATASOURCE="Mine">
SELECT Count(*) AS NumMatches
FROM OrderTable
WHERE DataSubmitted = #DateSubmitted# AND
ClientName = '#ClientName#' AND
ClientAddress = '#ClientAddress#' AND
ItemsOrdered = '#ItemsOrdered#
</CFQUERY>
<CFIF CheckDB.NumMatches>
You have already submitted this order!
<CFELSE>
.....
</CFIF>
HTH,
Kevin
>-----Original Message-----
>From: Darryl Lyons [mailto:[EMAIL PROTECTED]]
>Sent: Sunday, January 21, 2001 8:25 PM
>To: CF-Talk
>Subject: Stopping people doing the 'I clicked submit twice' thing..
>
>
>Has anybody found a way around this? It seems that whenever someone
clicks
>submit twice, data is inserted twice (updates are ok).
>
>-----------------------------------
>Regards,
>
>Darryl Lyons
>Web Development Team
>LogicWorld Internet
>
>Email : [EMAIL PROTECTED]
>Web : www.logicworld.com.au
>Team Site : webdevelopment.logicworld.com.au
>
>Phone : (07) 3230 8800
>Fax : (07) 2320 8801
>Technical Support : (07) 3230 8811
>
>' P L U G I N T O T H E W O R L D '
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
