Re: cftry inside of cftransaction ??

2006-11-08 Thread Jochem van Dieten
Will Tomlinson wrote: Can you wrap a query with cftry inside a cftransaction? Yes. It won't do anything for you unless you put an explicit commit in the catch (in which case the behaviour is 'implementation defined' so check your DB documentation) so I would recommend against it. Jochem

Re: cftry inside of cftransaction ??

2006-11-08 Thread Sinuy L
Figured someone would know and answer quicker than me testing this. Can you wrap a query with cftry inside a cftransaction? Thanks, Will I do this all the time in my CFCs... cftransaction cftry cfquery !--- Query here --- /cfquery cfquery

cftry inside of cftransaction ??

2006-11-07 Thread Will Tomlinson
Figured someone would know and answer quicker than me testing this. Can you wrap a query with cftry inside a cftransaction? Thanks, Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up

Re: cftry inside of cftransaction ??

2006-11-07 Thread Chris Peters
Figured someone would know and answer quicker than me testing this. Can you wrap a query with cftry inside a cftransaction? Thanks, Will I do this all the time in my CFCs... cftransaction cftry cfquery !--- Query here --- /cfquery cfquery

Re: cftry inside of cftransaction ??

2006-11-07 Thread Mingo Hagen
/cftransaction Will Tomlinson wrote: Figured someone would know and answer quicker than me testing this. Can you wrap a query with cftry inside a cftransaction? Thanks, Will ~| Introducing the Fusion Authority Quarterly

RE: cftry inside of cftransaction ??

2006-11-07 Thread Dave Watts
We do it like this: cftransaction action=begin isolation=serializable cftry !--- [mjh] Query here: --- cfquery ... /cfquery cftransaction action=commit / cfcatch cftransaction action=rollback / cfdump var=#cfcatch# cfabort