You shouldn't need to use a Session variable for your DSN .. especially if
you are going to be setting it over and over in your Application.cfm. That
defeats the purpose of having a Session variable anyway. You could get by
with another scope .. say Variables.ds, or something. That way, you
wouldn't have to worry about locking at all.
<cfif not IsDefined('Variables.ds')>
<cfset Variables.ds = "something_dev">
</cfif>
Todd Ashworth
----- Original Message -----
From: "Ricq Pattay" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 29, 2000 4:42 PM
Subject: CFLOCK datasource var?
| 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.
|
------------------------------------------------------------------------------
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.