TConnor@SC.RR.Com
|
| Posted: 11/23/2002, 12:25 PM |
|
I am working on a messaging application using the Task Manager Applocation Tutorial as a guide. I want to limit records in a grid to the current user and user_id 1. I am NOT ASP literate. My setup includes CCS 1.7, ASP 3.0 with Templates, Win2000, Access DB with Jet connection.
My Message Table includes:
MessageID
MessageToID
MessageFromID
My Users Table includes:
user_id
I want to show only those records that have the same User_ID and MessageToID or User_ID 1. If someone would please walk me through this?
Thank You
T Connor
TConnor@SC.RR.Com
|
|
|
 |
Edd
|
| Posted: 11/24/2002, 8:53 PM |
|
Am I looking at your issue too simplistically?
Can you not change your SQL statement to test if UserID = Userid From the Session (Not the URL) Also changing the AND to an OR condition at the end and adding an Expression (not a parameter from the same drop down) that says where "MessageToID = 1".
Hope this helps.
Edd
|
|
|
|
|
