That will work as long as that CF server is the only thing that is inserting into foo. You might consider enforcing this with your database security.
Only give insert permission on foo to your cfdbuser. _____________________________________________ Pete Freitag CTO, CFDEV.COM http://www.cfdev.com/ -----Original Message----- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 5: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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
