CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> Archive -> GotoCode Archive

 search in multiple tables

Print topic Send  topic

Author Message
Posted: 12/22/2003, 10:21 PM

Hi all,

visual query builder joining the tables very's cool.

but how can i make search by joining multiple tables.what i want is a search page which can search in 4 tables by using combobox.then the search results should be forwarded to a grid.there is a search option while making the grid.that does the work.but i need a seperate search page.

how it can be achieved with CCS?

Posted: 12/23/2003, 3:11 PM

Since searches are pure SQL then think about how the SQL is constructed. I would initially suggest your grid is based upon a stored procedure OR failing that a view (NOT SUGGESTED FOR BUSY SITES) or a SQL Statement that has a Union ALL statement.

If your database does not support Stored Procedures, Views or Unions - Rethink the application OR table structure.



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

PHP Reports

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

Home   |    Search   |    Members   |    Register   |    Login

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