Aaron
|
| Posted: 09/23/2002, 2:18 PM |
|
I am a big time knucklehead when it comes to programming, but I am trying to learn.
Right now, I need to be able to filter the contents of a grid by username. How in the world do I do it? I want to be able to mask out all records but those belonging to the username logged in, and still be able to search the displayed fields.
Any help, or a nudge in the right direction would be greatly appreciated.
Thanks!
Aaron
|
|
|
 |
Brent
|
| Posted: 09/23/2002, 5:10 PM |
|
It would help if you told us if you're using CC or CCS and PHP or ASP or JSP. :)
Brent
|
|
|
|
Aaron
|
| Posted: 09/23/2002, 7:06 PM |
|
See, told you I was a knucklehead...
CCS in ASP3. I want to filter grid display by UserName variable.
I'm getting closer to figuring it out, but I an still far from competent.
Aaron
|
|
|
|
Nicole
|
| Posted: 09/25/2002, 4:08 AM |
|
Aaron,
I suppose that user_id is stored in the table used as grid datasource.
In this case to display username on the form you should use two tables (the users table in addition), link them on user_id field and select both user_id and user_name to be selected from the tables.
To filter records and display the ones belong to logged in user only, add Table parameter user_id and compare it to session variable UserID.
|
|
|
|
Aaron
|
| Posted: 09/26/2002, 2:27 PM |
|
I ran across htis on the Tips & Articles page. Just what I needed!
http://www.gotocode.com/art.asp?art_id=198&
|
|
|
|
|
