RE: cftry cftransaction order

2002-09-19 Thread Mosh Teitelbaum
You might use something like: CFTRY CFTRANSACTION ACTION=Begin CFQUERY ... /CFQUERY CFTRANSACTION ACTION=Commit / CFCATCH TYPE=Database

Re: cftry cftransaction order

2002-09-19 Thread S . Isaac Dealey
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