-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Either I'm rusty or this is a little trickier to do...
The issue is that I have a TicketType, which has a Collection of Attribute which itself has a Collection of AttributeType.
When I do a select for a Collection of Attribute(s) for a TicketType (select * from ticket_types tt, attributes a where ticket_type=1 and tt.type_id = a.type_id order by a.attribute_order) I get a TicketType with its Attribute Collection and the Attribute Collection is correctly sorted by the order column. But I need to take this a step further because an Attribute has a Collection of AttributeValue(s), and I want those AttributeValue objects to also be sorted by a specific column.
In other words I need the 3rd IN query that OJB triggers to get the AttributeValue to be sorted...
What's the most efficient way to do this? I'd rather not do 2 selects myself, I like having one select and have OJB deal with the prefetched relationships... and sorting...
I have another example which goes deeper from project to tickettype etc...
Thanks R -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (Darwin)
iD8DBQFCBVhrJhqny0eCHK8RAvnjAJ0ZxKTArcUkJyxQlBZJ36JuEWOg5wCfXiCP 56Ietiiuhj5oIMVgHTFepT8= =WJoc -----END PGP SIGNATURE-----
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
