<cftry>
<cfset commitIt="yes">
<cftransaction action="begin">
<cfquery name="del_c" datasource="province">
delete from city where provinceID='#FORM.provinceID#'
</cfquery>
<cfquery name="del" datasource="province">
delete from province where provinceID='#FORM.provinceID#'
</cfquery>
<cfcatch type="database">
<cftransaction action="rollback">
<cfset commitIt="no">
</cfcatch>
<cfif commitIt>
<cftransaction action="commit">
<cfelse>
<cfset commitIt="yes">
</cfif>
</cftransaction>
</cftry>
------解决方案--------------------------------------------------------
<cftry>
<cfset commitIt="yes">
<cftransaction>
<cfquery name="del_c" datasource="province">
delete from city where provinceID='#FORM.provinceID#'
</cfquery>
<cfquery name="del" datasource="province">
delete from province where provinceID='#FORM.provinceID#'
</cfquery>
</cftransaction>
<cfcatch>
<cfset commitIt="no">
</cfcatch>
</cftry>