CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> CodeCharge Studio -> ASP

 stored procedure initial run

Print topic Send  topic

Author Message
r1xliquid

Posts: 41
Posted: 05/02/2007, 10:10 AM

I am trying to change the way a query is executed when i arrive on a page with a grid.

The grid is being populated by a stored procedure.

depending on what user is logged in i want to pass a parameter to the stored procedure accordigly.

If i were doing this with a table or view, i would put some code in the grid.beforeExecuteSelect that alters the datasource.where to produce what i am looking for.

but how can i dynamically change the parameter of the stored procedure before the page is displayed?
View profile  Send private message
r1xliquid

Posts: 41
Posted: 05/02/2007, 3:41 PM

for reference:
this is for a form submited with post: grid.DataSource.Parameters("url"+controlName)=x


that does it!
View profile  Send private message

Add new topic Subscribe to topic   


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

PHP Reports

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

Home   |    Search   |    Members   |    Register   |    Login


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