CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 Show/Hide gridrows, records users

Print topic Send  topic

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

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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