Help locking 3 queries to fire without interuption


i in bind of situation right now. have 3 queries need run in order. queries 3 different cfquery blocks followed 1 after another. first 1 used turn on globaly, , middle runs guts, , last turns off global setting. need make sure nothing pokes database while 3 queries doing thing. beleive cftransaction not me in case. have idea of how approach this?

thanks,
brian evans

e. bewebdev@gmail.com

<cftransaction> should work if database supports . rdbms? instance, oracle has update clause lets treat select update until released commit or rollback, etc. there possibility of using stored procedures.

phil


More discussions in Advanced Techniques


adobe

Comments

Popular posts from this blog

Convierte tu Raspberry en un NAS. Firmware fvdw-sl 15.3 - Raspberry Pi Forums

Rasperry Wifi LAN Controller - Raspberry Pi Forums

Unlock car with bluetooth and car key