You might use something like:
<CFTRY>
<CFTRANSACTION ACTION="Begin">
<CFQUERY ... >
</CFQUERY>
<CFTRANSACTION ACTION="Commit" />
<CFCATCH TYPE="Database">
Database Exception
<CFTRANSACTION ACTION="Rollback" />
</CFCATCH>
</CFTRANSACTION>
</CFTRY>
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
> -----Original Message-----
> From: jon hall [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 19, 2002 1:05 PM
> To: CF-Talk
> Subject: cftry cftransaction order
>
>
> I have a set of database updates that I need to nest in a
> cftransaction, but I also want to use a cftry/cfcatch block for error
> handling. If I put the cftransaction outside the try/catch block if
> there is an error, the catch block will execute and abort any further
> processing, if I put the cftrans tags inside the block, is CF smart
> enough to know that the transactions should be rolled back before the
> catch block is executed?
>
> What would be the correct way to do this?
>
> --
> jon
> mailto:[EMAIL PROTECTED]
>
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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
