CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> CodeCharge -> General/Other

 Search from 2 tables with query

Print topic Send  topic

Author Message
From Nantucket
Posted: 07/13/2005, 5:36 AM

I am relatively new to Code Charge and am having trouble with a search builder.

I have 2 tables, one of menu items the other of meals. The ID from the meal table is joined with the meal column in the menu table. In the search I want a list box with the meal.text so the viewer can view all menu items from a particular meal. I did a query with a right join menu.meal to meal.ID. I get nothing in the search. I also specified the Data Source as Meal table, Bound column as meal.id and text column as meal.text. Should it be a left join?? or am I doing something else wrong??

Thank you

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.

PHP Reports

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

Home   |    Search   |    Members   |    Register   |    Login


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