using cftransaction with queries

[Mattastic]

Hi,

If cfquery fails, how can cftransaction recognise this?

If a query fails I need to roll it back.

Thanks

[cf_menace]

[url]http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-c15.htm[/url]



<cftransaction action="BEGIN">

<cftry>

<cfquery ... >
INSERT statement
</cfquery>
<cfcatch type="Database">
<cftransaction action="ROLLBACK" />
</cfcatch>

</cftry>

<cftransaction action="COMMIT" />

</cftransaction>

[Latino]

[url]http://www.tecito.com:[/url] Hi. I need some clarification on this topic too. Is
it necessary to use and EXCLUSIVE CFLOCK around the CFTRANSACTION? I have been
using cftransactions around my queries without CFLOCK, but i was reading an
O'Reilly book, they were using both cflock and cftransaction in their queries.
Bye.

[vkunirs]

Hi

I think we dont reuiqre to use the cflock for cftransaction.

and another thing is the even we dont require to use the rollback ofthe
transaction in the cftransaction.
this will take care automatically. that means either all the cfqueries will be
executed or none.