> <CFQUERY NAME="GetUsers" DATASOURCE="DSN">
> SELECT User_ID, FullName, Login
> FROM Users
> WHERE session.user_ID = #CurrentUser.User_ID#
> ORDER BY Login
> </CFQUERY>
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/[email protected]/
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.
