Question
cftransaction question
Hi all, for a cftransaction similar as shown below,
<cftransaction action="BEGIN">
<cftry>
<cfquery ............>
SQL statement
</cfquery>
<cfquery ............>
SQL statement
</cfquery>
other statements
<cftransaction action="commit" /> <!--- is this necessary??? --->
<cfcatch type="any">
<cftransaction action="rollback" />
<cfoutput>
#cfcatch.detail#
</cfoutput>
</cfcatch>
</cftry>
</cftransaction>
Is the <cftransaction action="commit" /> necessary? What happens if I remove this line?
<cftransaction action="BEGIN">
<cftry>
<cfquery ............>
SQL statement
</cfquery>
<cfquery ............>
SQL statement
</cfquery>
other statements
<cftransaction action="commit" /> <!--- is this necessary??? --->
<cfcatch type="any">
<cftransaction action="rollback" />
<cfoutput>
#cfcatch.detail#
</cfoutput>
</cfcatch>
</cftry>
</cftransaction>
Is the <cftransaction action="commit" /> necessary? What happens if I remove this line?
AdChoices