Help locking 3 queries to fire without interuption

[ismokev8s]

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?

Thanks,
brian evans

e. bewebdev@gmail.com

[paross1]

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

Phil

[Iceborer]

try using <cftransaction isolation="serializable">