帮我看看这段代码有什么错误?????多谢了!!!!!!!!!
<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>
