|
From: Buddy T. <me...@my...> - 2006-08-15 07:06:49
|
Hi, I need some help with DataObjectWrappers. Here is my situation I have two tables: Categories and Subcategories. Subcategoies table contains a category_id column that references what main category it belongs to. I want to join the two tables to get the name of the main category for each subcategories. I saw one example where someone join two tables using two DataObjectWrapper object references to create a single array but I'm afraid this might make my application use too many MySQL connections to do a joined table operation that could be done in a single connection. Is there a way to create a joined table DataObjectWrapper (like CategoriesSubcategoriesWrapper or something) Also, what is the best way to sort the order of a DataObjectWrapper (like SQL's ORDER BY)? Do I just sort the array I create? And how do you limit the DataObjectWrapper's find() (like LIMIT in SQL)? Thank you, Buddy Toups Graphic Design and Web Development http://www.mydesignbuddy.com |