MySQL hasn't support transactions very well (if at all) in previous
versions. Try searching the forums for some hints. Here's one that I
found:
http://forums.allaire.com/coldfusion/messageview.cfm?catid=10&threadid=22086
1&highlight_key=y&keyword1=cftransaction&keyword2=mysql
> -----Original Message-----
> From: Chad Gray [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 25, 2001 10: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