RE: still confused re locking

2001-11-11 Thread Dave Watts
> many thanks to all who answered - lessened my confusion beautifully. > > One final quick question > in the code below I actually have 2 hidden fields > > should there be any problems locking the 2 variables in the > one lock as below or should I use 2 separate locks?? One lock is all you nee

Re: still confused re locking

2001-11-11 Thread Seamus Campbell
many thanks to all who answered - lessened my confusion beautifully. One final quick question in the code below I actually have 2 hidden fields should there be any problems locking the 2 variables in the one lock as below or should I use 2 separate locks?? Thanks again Seamus >

Re: still confused re locking

2001-11-11 Thread tom muck
Put them into temporary page-level variables and lock them when transferring the values, so that you don't have to lock the query -- that is bad practice. Something like this: SELECT User_ID, nickname, expiry_date FROM tbl_client WHERE user_id=#variables.temp# As to your second situat

Re: still confused re locking

2001-11-11 Thread Tracy Bost
Try something like this: > SELECT User_ID, nickname, expiry_date > FROM tbl_client > WHERE user_id=#user_ID# > - Original Message - From: "Seamus Campbell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, Novem

Re: still confused re locking

2001-11-11 Thread Don Vawter
if you are not SETTING the session vars I reccommend locking in application.cfm and setting them to request scope vars. - Original Message - From: "Seamus Campbell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, November 11, 2001 8: