CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> Archive -> GotoCode Archive

 search in multiple tables

Print topic Send  topic

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

Hi all,

visual query builder joining the tables very effectievely.it'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?



Edd
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.

Edd

   


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.