Origianlly I didn't want use <referece-descriptor>, but it has become apparent that I'd need it. I appreciate your help!
Sincerely, Daehyun
Daniel Perry wrote:
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
