At 02:32 PM 2/14/02 -0500, you wrote: >You could use a <cftransaction> and group your cfquery and cfmail >together. > >__
We are currently using a <CFTRANSACTION> wrapped around a CFINSERT and query getting back the New ID of the new record created . . .doesn't seem to hold up . . . jim >____________________ >steve oliver >atnet solutions, inc. >http://www.atnetsolutions.com > > >-----Original Message----- >From: Jim Mixon [mailto:[EMAIL PROTECTED]] >Sent: Thursday, February 14, 2002 2:31 PM >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 . . . > > > ______________________________________________________________________ Get Your Own 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=coldfusionb 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
