application and session variables together

2000-05-04 Thread Deanna L. Schneider
How do you lock when you have two different kinds of variables in the same query? For example: cfquery name="example" datasource="#application.dsn#" SELECT * FROMusers WHEREusers.userid = #session.userid# /cfquery Do you lock the where statement separately, nested in the overall

RE: application and session variables together

2000-05-04 Thread Aidan Whitehall
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

Re: application and session variables together

2000-05-04 Thread Fred T. Sanders
l Message - From: "Deanna L. Schneider" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 04, 2000 7:52 AM Subject: application and session variables together How do you lock when you have two different kinds of variables in the same query? For example: cfq