[Wasp-users] (no subject)

[Buddy T. <me...@my...>]

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