You can always localize your session variable like this:
<cflock scope="session" timeout="20" type="exclusive">
<cfset myLocalVar = "#SESSION.myVar#">
</cflock>
You can use the local variable myLocalVar in your query. That way you don't
have to lock large chunks of code.
-Elizabeth
-----Original Message-----
From: Brunt, Michael [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 2:08 PM
To: CF-Talk
Subject: Session Vars and cfquery - cflock where?
When using a session variable in a <cfquery where should the <cflocks be?
Around the whole <cfquery or just around the line calling the session var?
Mike Brunt
Sempra Energy
213.244.5226
"An elephant is a mouse with an operating system."
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
