CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.

YesSoftware Forums -> Archive -> GotoCode Archive

 Show/Hide gridrows, records users

Print topic Send  topic

Author Message
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,

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.


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

Internet Database

Visually create Web enabled database applications in minutes.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by  and YesSoftware, Inc.