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]>
