Transaction support in mySQL:
http://www.mysql.com/doc/M/i/Missing_Transactions.html
Perhaps you could a lot of your error catching/validation inside of your
mySQL SQL?
---
Billy Cravens
Web Development, EDS
[EMAIL PROTECTED]
-----Original Message-----
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 9:54 AM
To: CF-Talk
Subject: MySQL and CFTRANSACTION
Thanks for the code Mike. It is working now.. Kinda.
Now im getting an error that my database driver does not support
<CFTRANSACTION> Im using MySQL.
So i take it i will only be able to use CFTRY and CFCATCH to watch for
errors on the SQL statements....?
Anyone have a work around or more info on <CFTRANSACTION> and MySQL?
At 03:26 PM 9/25/2001 +0100, you wrote:
>You need to change how the try works with transaction...
>
><CFTRANSACTION>
> <CFTRY>
> <!--- Queries Here --->
>
>
>
> <CFTRANSACTION ACTION="COMMIT"/>
> <CFCATCH>
> <!--- We have experienced an error...
> Rollback the inserts and set
>the commit flag
> to false for processing later
>--->
> <CFTRANSACTION ACTION="ROLLBACK"/>
> <!--- Failed to insert all the information
>into the database --->
> INSERT FAILED :(
> <CFABORT>
> </CFCATCH>
> </CFTRY>
></CFTRANSACTION>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
