>Aren't ChassisPool instances unique with regard to the pk? Yes, they are. But doesn't ODMG support distinct select for specified fields. (eg
select distinct ChassisPool.name from "+ChassisPool.class.getName(); -----Original Message----- From: Oleg Nitz [mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 7:09 PM To: OJB Users List Subject: Re: Question about OQL and Distinct? Aren't ChassisPool instances unique with regard to the pk? Try something like String sql = "select distinct ChassisPool.name from "+ChassisPool.class.getName(); against CVS version of OJB :-) Oleg On Friday 10 January 2003 19:46, Douglas Montanus wrote: > I am having problem implementing the "distinct" in my query. I have > tried it many different ways but can't seem to get the result I desire. > Here is an example: > > String sql = "select distinct ChassisPool from > "+ChassisPool.class.getName(); > > Douglas -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
