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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
