[thelist] ColdFusion Queries: All or nothing.

rudy r937 at interlog.com
Sun May 13 14:56:35 CDT 2001


> I have a couple of queries (2 or 3) which all need to be run. 
> But, just in case, if one produces an error, is there a way to 
> not run any of them? 

hi jon

use this --

<CFTRANSACTION 
    ACTION="BEGIN" or "COMMIT" or "ROLLBACK"
    ISOLATION="Read_Uncommitted" or
                 "Read_Committed" or
                 "Repeatable_Read" >
</CFTRANSACTION>

good example at
/cfdocs45/CFML_Language_Reference/2_ColdFusion_Tags/lr2_098.htm#1973470


rudy






More information about the thelist mailing list