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>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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