[thelist] ColdFusion Queries: All or nothing.

[Joshua OIson]

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

-joshua

----- 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.