Is it necessary to lock session variables while doing a StructDelete() on
them?
Also .. say one is reading or writing a Session variable and an Application
variable in the same line of code. What scope would one use on the lock if
one couldn't get an individual lock around each variable?
<cfif not IsDefined('Session.Variable') or not
Len(Trim('Application.Variable'))>
blah blah blah
</cfif>
??
Also .. is nesting locks a bad idea? For example:
<cfquery name="qryQuery" datasource="#Application.DSN#">
SELECT blah, blah2, blah3
FROM this_table
WHERE table_id = #Session.TableID#
</cfquery>
Is this the only way to do it?
<cflock scope="Application" timeout="10" type="ReadOnly">
<cfquery name="qryQuery" datasource="#Application.DSN#">
SELECT blah, blah2, blah3
FROM this_table
WHERE table_id = <cflock scope="Session" timeout="10"
type="ReadOnly">
#Session.TableID#
</cflock>
</cfquery>
</cflock>
That seems awfully inefficient.
Todd Ashworth
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]