CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> PHP

 search and grid

Print topic Send  topic

Author Message
kirchaj

Posts: 215
Posted: 05/28/2008, 1:49 PM

Is there a way to keep a grid from loading data from the database until the user enters a search criteria?

I know I can put the search on a separate page and call the grid, but I would like to keep both items on the same page. I have searched the forums and have not found this particular scenario.

Thanks for the help
TK
View profile  Send private message
kirchaj

Posts: 215
Posted: 05/28/2008, 2:05 PM

After playing with this for a minute I have a solution that isn't too bad but still requires the extra search page. I have a search page with no grid that calls the page with both the search and grid on it.

But I would still like a one page solution.

TK
View profile  Send private message
aradi

Posts: 66
Posted: 05/28/2008, 2:28 PM

Take a look at this post:

http://forums.codecharge.com/posts.php?post_id=96980&s_...arameter+search
View profile  Send private message
mentecky

Posts: 321
Posted: 05/28/2008, 6:20 PM

Quote kirchaj:
Is there a way to keep a grid from loading data from the database until the user enters a search criteria?

I know I can put the search on a separate page and call the grid, but I would like to keep both items on the same page. I have searched the forums and have not found this particular scenario.

Thanks for the help
TK

Yes... put a hidden field in the search grid, for example ShowGrid. Set it's default value to "1". In the grid's before show events add a "Hide/Show" action.

Action: Hide
Condition: Does not equal (<>)
Param1: Name: ShowGrid
Param1: Source Type: URL
Param2: Name: '1'
Param2: Source Type: Expression

That will hide the grid unless they submit a search.

Rick


_________________
http://www.ccselite.com
View profile  Send private message
wkempees


Posts: 1679
Posted: 05/29/2008, 4:53 AM

@R,
That will hide the grid, but it will still load it's data.
It could be part of the where though, making the grid select zero rows.

Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)

if you liked this info PAYPAL me: http://donate.consultair.eu
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.

Web Database

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.