[thelist] ColdFusion Queries: All or nothing.

Joshua OIson joshua at alphashop.net
Mon May 14 09:30:51 CDT 2001

If you are running a database that supports transactions, wrap your queries
in <CFTRANSACTION></CFTRANSACTION>  It does *exactly* what you are asking.


----- Original Message -----
From: "jon steele" <jjsteele22 at yahoo.com>
Subject: [thelist] ColdFusion Queries: All or nothing.

> Hi,
> 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? So it's either ALL ARE RUN W/ SUCCESS MESSAGE or NONE ARE RUN W/
> ERROR MESSAGE. This is becuase I don't want a job to be left half done.
> If only the first query is run, the second gives an error, then the use
> goes BACK, and tries it again, they are guaranteed an error (b/c the
> first query was already run).
> Thanks,
> Jon.

More information about the thelist mailing list