Yes, you could use CFtransaction for this type of isolation, but this can also cause problems that you wouldn't see with cflock. Cftransaction isoloation='serializabile' for example will give you an exclusive lock to all tables within the transaction (most restrictive level of isloation). Depending on what you're doing, this can be desirable or problematic as this can easily cause database deadlocks which are almost always highly frustrating to the end user, and are usually equally frustrating to debug. Cflock will not (directly) cause database deadlocks, but can be problematic if you have a large number of requests that are going to be using the cflock'ed code as a lock will wait (until timeout) for the locked resource to be released.
So potential database lock error vs potential cflock timeout error - the choice is yours. :) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288206 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
