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 -> General/Other

 using url of a listbox in query where

Print topic Send  topic

Author Message
paolosenni

Posts: 1
Posted: 07/03/2013, 10:31 AM

Hello,
are new and fairly inexperienced.
I need to create a grid that displays lines based on a query. This query has the field "where" tied to a listbox which is placed in another page. So, how do I reference the selected value of the listbox in the field where of the query?
I have tried in many ways but nothing is displayed in the grid or not filtered at all.
Any suggestions?
Thank you very much in advance.


Paolo
View profile  Send private message
Lucius

Posts: 220
Posted: 07/03/2013, 3:44 PM

If its on a separate page you need to pass the information first, there are many ways to do this:
- store value in a cookie
- pass the value as a GET parameter to the second page
- save as session variable

Decide on one and then code it at the point when user selects value from the Listbox. I guess you have the problem at this point.

Afterwards when user enters the page with the grid you need to check for the stored value and filter the grid accordingly. This one is easy, you can define it in the WHERE condition for the grid datasource.
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.