What kind of lock are you doing? Scope/name/exclusive?
...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 4:55 PM To: CF-Talk Subject: Using CFLock around a query The main question is: Is it ok to put a CFLock around one or more cfqueries that are nested in a Cftransaction. E.G.: <cflock> <cftransaction> <cfquery name="q1"> update table1 yadda yadda....... </cfquery> <cfquery name="q2"> delete table1 where ...... </cfquery> </cftransaction> </cflock> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277355 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4