Rene
|
| Posted: 04/16/2003, 5:09 AM |
|
Hello you all,
Using CCS 2, ASP3, Access, IIS, XP-Pro
Hope you can help me. I've searched everywhere but still don't get it (maybe because I am almost blank to programming and syntax). What I'm trying to achieve is the following: A user logs in, after that moment he only gets to see gridrows and records that belong to his member_Id field. The member_Id field is my UserID field in projectsettings>security.
Where do I put the code to achieve this? And what is that code?
I've been trying something like:
If CCGetUserID <> member_Id Then
But I'm lost. Could someone provide me with a wizard like "walk Thru"?
I'm sure other people (as dumb as me, probably) would highly appreciate this.
Thanks alot,
Rene
|
|
|
|
David Cumming
|
| Posted: 12/15/2003, 12:56 AM |
|
To limit a data source to that matching the UserID you can do this:
Edit the data source for a form
Add a condition to the where clause
The "Table Parameter" box allows you to add the field that should be restricted on the left hand side (member_Id) and the "Parameter Source" to restrict it to on the right hand side. Set the right hand side to UserID with type: Session. (Case is important for UserID)
This is saying, for the data source of this table, limit the rows to WHERE the member_Id is the session variable UserID.
Hope this makes sense.
|
|
|
|
|
|
