I am in a bind of a situation right now. basically i have
three queries that i need to run in order. The queries are 3
different cfquery blocks followed one after another. The first one
is used to turn something on globaly, and the middle runs the guts,
and the last turns off the global setting. I need to make sure that
nothing pokes the database while those 3 queries are doing their
thing. i beleive that cfTransaction will not help me in this case.
Does anyone have an idea of how to approach this?
<CFTRANSACTION> should work if your database supports
it . What is your RDBMS? For instance, Oracle has FOR UPDATE clause
that lets you treat a SELECT like an UPDATE until released by a
COMMIT or a ROLLBACK, etc. There is also the possibility of using