I know that the database itself can handle transactions using InnoDB tables.
The error I'm getting from CF is that the ODBC DRIVER can't handle them.
+-----------------------------------------------+
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
-----Original Message-----
From: Chad [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 04, 2002 2:29 PM
To: CF-Talk
Subject: RE: CFLOCK instead of CFTRANSACTION
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
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
