At 12:42 PM 2/14/02 -0800, you wrote: >also, how are you generating the primary key for the insert statement? >If >you are using SELECT MAX() then you can have issues without using >CFTRANSACTION.
I am using the <CFTRANSACTION> wrapped around the CFINSERT and the GET MAX(id) back query . . . I am thinking that when the second user also submits the form simultaneoulsy , the GET ID BACK query ends up returning the ID from the SECOND user because that form got INSERTED after the first, but before the first get GET the ID BACK could complete!! The only unanswered question is where is the other form's data . . .it never makes it to the table to be stored . . .??? Since email addresses must be unique, I am thinking of having it get the ID via the Email address instead of the MAX(id) method . . . thoughts? jim >+-----------------------------------------------+ >Bryan Love > Macromedia Certified Professional > Internet Application Developer > Database Analyst >Telecommunication Systems >[EMAIL PROTECTED] >+-----------------------------------------------+ > >"...'If there must be trouble, let it be in my day, that my child may >have >peace'..." > - Thomas Paine, The American Crisis > > > >-----Original Message----- >From: Bryan Love [mailto:[EMAIL PROTECTED]] >Sent: Thursday, February 14, 2002 12:25 PM >To: CF-Talk >Subject: RE: A-Z 0-9 form validation > > >I think you have missed the problem... If user2 gets user1's info, then >where did user2's email address come from? I assume it came from the >form, >which means you haven't lost the form information. These problems can >be >tricky, so take your time and go over the thing with fine-tooth comb. > >+-----------------------------------------------+ >Bryan Love > Macromedia Certified Professional > Internet Application Developer > Database Analyst >Telecommunication Systems >[EMAIL PROTECTED] >+-----------------------------------------------+ > >"...'If there must be trouble, let it be in my day, that my child may >have >peace'..." > - Thomas Paine, The American Crisis > > > >-----Original Message----- >From: Adrian Cesana [mailto:[EMAIL PROTECTED]] >Sent: Thursday, February 14, 2002 11:04 AM >To: CF-Talk >Subject: A-Z 0-9 form validation > > >Anyone have a good snippet of code to do A-Z 0-9 form validation server >side? Im trying to roll my own but its starting to get ugly.... > >Thanks,Adrian > > > > ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
