Since its an INSERT is seems like this should not happen, I could see this happening with an UPDATE. In any case without reviewing your code you may want to CFLOCK the INSERT EMAIL process. If its a heavy usage site I would look further into why this is happening and code around it rather than using a CFLOCK.
Adrian -----Original Message----- From: Jim Mixon [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 11:31 AM To: CF-Talk Subject: RE: A-Z 0-9 form validation Hi list . . . just a little help please . . . I have a form that collects data, inserts a new record and send out a confirmation email to the submitter . . and CC's me with form info also . . It seems that when two or more people submit the form at the same time, their session or data overlap some way . . for the sake of argument, the first form data is stored and the process completes correctly . . .the second form data is lost and the second submittor receives the first submittor's info in the confirmation emails . . . any way to insure the entire process is handled exclusively and prevent any type of apparent overlapping??? thanks a million in advance . . . ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
