addOrderByAscending("b.name");
Make sure you use capitalisation as per your repository.xml - normally why
things dont work for me on first try!
Daniel.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 10 May 2004 10:23
To: [EMAIL PROTECTED]
Subject: Setting addOrderByAscending() with foreign attribute
Hi all,
I'd like to sort the result set based on a field from another table.
With SQL it'd be like:
SELECT A.* FROM A, B WHERE A.AID = 10 AND A.BID = B.BID
ORDER BY B.NAME;
(A.BID is a foreign key to table B).
How would you achieve the same effect with OJB?
Thanks!
Sincerely,
daehyun yoon
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
