How to stop the process if there is error on Coldfusion template 1

[771212]

Does anybody know if there is any tag that prevents the page process if there is an error on the page?

For example, I have couple of cfquery to delete something.

<cfquery name="delete1" datasource="#request.dsn#">
delete from pages
where pageid = #form.pageid#
</cfquery>

<cfquery name="delete2" datasource="#request.dsn#">
Delete from into pageattachment
where pageid = #form.pageid#
</cfquery>

You will notice, I have a wrong “into” syntax on the second query, that will cause some problem, but when the coldfusion catch the problem, the first query is already prosecuted, is there any way to stop the process if all any query is wrong. Something like “cflock” to surround the whole action page to make sure everything is right, but I know cflock is not for this.

Thanks,

 

[Wullie]

CFTRANSACTION is what you are looking for.

http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/Tags-pt315.htm

Hope this helps

Wullie

Fresh Look - Quality Coldfusion 7/Windows Hosting
YetiHost - Coming Soon

The pessimist complains about the wind. The optimist expects it to change. The leader adjusts the sails. - John Maxwell

 

[771212]

yes!
I think this is the one I want, thank u!