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.