In my application.cfm I set a session var for all my queries' datasource
like this:

<cflock scope="session" timeout="30" type="exclusive">
 <cfset session.ds = "something_dev">
</cflock>

So... Do I need to read-only lock every reference to session.ds in all my
other templates where I have a query using that datasource session var?
e.g.,

<cfquery name="get_year" datasource=#session.ds#>
select sysdate from dual
</cfquery>

Since session.ds is always identical for every user of this site, what does
it matter if it's locked or not?

~~~~~~~~~~~~~~~~~~~~~~~~
Ricq Pattay <[EMAIL PROTECTED]>
Univ of Minnesota - Twin Cities
College of Veterinary Medicine




------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to