CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> Archive -> GotoCode Archive

 filter rows but all rows for admin

Print topic Send  topic

Author Message
Posted: 11/21/2003, 11:32 AM

In my grid i wish to show all records if the user logged in is Admin but only show the logged in user's rows if the logged in user is a regular user.

showing the logged in users i accomplished via the querry builder.

But now i'm thinking that i'll have to remove the where from the querry builder and do something in a before show event.

Any suggestions?
Posted: 11/22/2003, 5:26 AM

I suppose that you can modify the WHERE clause in the Before Execute Select event (refer to CCS Help for sample code) if the logged in user is administrator remove the relevant WHERE condition.


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

Web Database

Join thousands of Web developers who build Web applications with minimal coding.

Home   |    Search   |    Members   |    Register   |    Login

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