> How do you lock when you have two different kinds of variables in the same
> query?
>From Mastering ColdFusion 4, assign the application variables to a standard
page variables, surrounded by the relevant CFLOCK. Then, refer to
variables.WhatEver in the CFQUERY, locking for the session variable...
thusly
<CFLOCK NAME="#application.ApplicationName#" etc>
<CFSET variables.DB = application.DB>
</CFLOCK>
<CFLOCK NAME="#session.SessionID#" etc>
<CFQUERY DATASOURCE="#variables.DB#"... >
SELECT etc
</CFQUERY>
</CFLOCK>
--
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services
http://www.netshopperuk.co.uk/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.