Upgraded to RC6, and everything seemed to be fine..... until now :) One bit of code (that grabs a list - proxied collection) causes some nasty sql errors. Upon calling the .size() method it generates some sql (I'll hazard a guess of a COUNT query) without a group by statement.
I seem to remember someone pointing this out before, but cant find the message.... Is there an easy fix? 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]
