Re: CF Query Problem with Session Variables
P.S. Jeremy, don't forget to those session variables ;) Todd Ashworth - Original Message - From: "Ricq Pattay" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 11, 2000 11:24 AM Subject: Re: CF Query Problem with Session Variables | Try: | | | | | SELECT User_ID, FullName, Login | FROM Users | WHERE User_ID = #session.user_ID# | ORDER BY Login | | | And you'll probably need single quotes around #session.User_ID# if it's a | non-numeric field. | | | Ricq Pattay <[EMAIL PROTECTED]> | Univ of MN College of Veterinary Medicine | | | | - Original Message - | From: Jeremy Toevs <[EMAIL PROTECTED]> | To: <[EMAIL PROTECTED]> | Sent: Friday, August 11, 2000 10:08 AM | Subject: CF Query Problem with Session Variables | | | Hey CF People, | | I am storing the current users id in a session variable using the following: | | | | Now I am trying to write a query that uses that. | | | SELECT User_ID, FullName, Login | FROM Users | WHERE session.user_ID = #CurrentUser.User_ID# | ORDER BY Login | | | Is it possible to use it, or am I just writing it wrong? | | Thanks in advance! | | Jeremy -- 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.
RE: CF Query Problem with Session Variables
And you could remove the excessive # signs too: > Try: > > > > > SELECT User_ID, FullName, Login > FROM Users > WHERE User_ID = #session.user_ID# > ORDER BY Login > > > And you'll probably need single quotes around #session.User_ID# if it's a > non-numeric field. > > > Ricq Pattay <[EMAIL PROTECTED]> > Univ of MN College of Veterinary Medicine > > > > - Original Message - > From: Jeremy Toevs <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, August 11, 2000 10:08 AM > Subject: CF Query Problem with Session Variables > > > Hey CF People, > > I am storing the current users id in a session variable using the > following: > > > > Now I am trying to write a query that uses that. > > > SELECT User_ID, FullName, Login > FROM Users > WHERE session.user_ID = #CurrentUser.User_ID# > ORDER BY Login > > > Is it possible to use it, or am I just writing it wrong? > > Thanks in advance! > > Jeremy > > -- > -- > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_tal > k 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. -- 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.
RE: CF Query Problem with Session Variables
> > SELECT User_ID, FullName, Login > FROM Users > WHERE session.user_ID = #CurrentUser.User_ID# > ORDER BY Login > But...is session.user_ID a table in your database. What you probably want is WHERE User_ID = #session.user_ID# Dana Larose Database Monkey Canadian Web Design & Consulting Inc. A: 701-281 McDermot Avenue (McDermot & King) P: 204-946-5155 C: 204-228-0477 F: 204-946-5156 E: [EMAIL PROTECTED] W: http://www.cdnwebdesign.com -- 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.
Re: CF Query Problem with Session Variables
Try: SELECT User_ID, FullName, Login FROM Users WHERE User_ID = #session.user_ID# ORDER BY Login And you'll probably need single quotes around #session.User_ID# if it's a non-numeric field. Ricq Pattay <[EMAIL PROTECTED]> Univ of MN College of Veterinary Medicine - Original Message - From: Jeremy Toevs <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 11, 2000 10:08 AM Subject: CF Query Problem with Session Variables Hey CF People, I am storing the current users id in a session variable using the following: Now I am trying to write a query that uses that. SELECT User_ID, FullName, Login FROM Users WHERE session.user_ID = #CurrentUser.User_ID# ORDER BY Login Is it possible to use it, or am I just writing it wrong? Thanks in advance! Jeremy -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/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.
CF Query Problem with Session Variables
Hey CF People, I am storing the current users id in a session variable using the following: Now I am trying to write a query that uses that. SELECT User_ID, FullName, Login FROM Users WHERE session.user_ID = #CurrentUser.User_ID# ORDER BY Login Is it possible to use it, or am I just writing it wrong? Thanks in advance! Jeremy -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.