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

 Search grid

Print topic Send  topic

Author Message
fady005


Posts: 115
Posted: 02/15/2007, 6:40 AM

Hello,
I would like to know if it is possible with CCS to make a search grid with 2 fields of two binded tables of a database.
If Yes please tell me how because I'm having some trouble doing it.
Thanks ;-)
_________________
Be inventive !
View profile  Send private message
LH_13

Posts: 30
Posted: 02/15/2007, 7:41 AM

Possible.
Try to use Query Builder.
Joins and perhaps custom SQL.
_________________
Sorry my english!
View profile  Send private message
fady005


Posts: 115
Posted: 02/15/2007, 8:52 AM

I already tried it. It allow the selection of fields in only one table.
I also tried to modify the code but it's not working... :-(
_________________
Be inventive !
View profile  Send private message
LH_13

Posts: 30
Posted: 02/15/2007, 8:58 AM

Try press add button in Query Builder.
You can add new table. Than create link by fied.
Or change type from Table to SQL and write your custom sql.
_________________
Sorry my english!
View profile  Send private message
fady005


Posts: 115
Posted: 02/16/2007, 12:51 AM

In Query Builder I can select only one table and then add fields. Where can I add fields ?
For the SQL can you give me the code if my two tables are named table1 and table2 and my two fields field1 and field2.
Thanks :-D
_________________
Be inventive !
View profile  Send private message
LH_13

Posts: 30
Posted: 02/16/2007, 1:31 AM

Be intently!
You have add button at the buttons panel.
Here you CAN ADD NEW table.
_________________
Sorry my english!
View profile  Send private message
fady005


Posts: 115
Posted: 02/16/2007, 1:43 AM

I can't find it... :-<
Can you please put a screen capture ?
Thanks
_________________
Be inventive !
View profile  Send private message
LH_13

Posts: 30
Posted: 02/16/2007, 2:24 AM


_________________
Sorry my english!
View profile  Send private message
fady005


Posts: 115
Posted: 02/16/2007, 4:06 AM

Ah ok... :-O
So if I want my two grid to show the result of the search box I should add to each one a where condition that take the parameter from the URL....

Thanks It's working :-D
_________________
Be inventive !
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.