hi scott, it works for me. i use the latest from cvs, but imo this part has not changed over a long time:
query = new QueryByCriteria(Konto.class, crit,true); SELECT DISTINCT A0.idPerson,A0.saldo,A0.nummer,A0.id FROM tabKonto A0 INNER JOIN tabPerson A1 ON A0.idPerson=A1.id WHERE ((A1.name LIKE ? ) AND A1.vorname LIKE ? ) AND A0.saldo >= ? jakob ----- Original Message ----- From: "Weaver, Scott" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 01, 2002 10:26 PM Subject: Query.setDistinct() is not working > Has anybody else experienced this issue. The logic was working fine when I was using 0.9.4 but seems to be broke in 0.9.7. I've also tried QueryFactory.newQuery(Class, Criteria, true) which does not work either. Any Clues??? > > My class-descriptor for this table is simple, just a single field mapped to a column containing a year in decimal format. > > <class-descriptor class="com.rippe.lms.ojb.om.BillingYear" table="TOTC"> > <field-descriptor id="1" name="year" column="FSCY" jdbc-type="DECIMAL" primarykey="true" conversion="com.rippe.essential.om.conversion.BigDecimalToIntFieldConversion "/> > </class-descriptor> > > Thanks, > Scott > -- To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
