MySQL can do transactions you just need to use the database type: InnoDB I have never use this myself, but according to the mysql.com documentation you can use it.
> -----Original Message----- > From: Bryan Love [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 04, 2002 4:04 PM > To: CF-Talk > Subject: CFLOCK instead of CFTRANSACTION > > The MySQL driver does not support CFTRANSACTION. Except for the inability > to rollback, does anyone see a problem with using a CFLOCK tag instead? > > <cflock name="fooUpdate" timeout="5"> > <cfquery name="" datasource="#request.mainDSN#"> > INSERT INTO foo > VALUES( bla bla ) > </cfquery> > <cfquery name="new" datasource="#request.mainDSN#"> > SELECT max(fooID) AS ID > FROM foo > </cfquery> > </cflock> > > +-----------------------------------------------+ > 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 > > "Let's Roll" > - Todd Beamer, Flight 93 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
