读书人

帮小弟我看看这段代码有什么东东?谢谢

发布时间: 2012-02-04 15:43:09 作者: rapoo

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

读书人网 >其他服务器

热点推荐