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