RE: Select MAX

2004-04-14 Thread Carles Duque
les -Mensaje original- De: Gelhar, Wallace Joseph [mailto:[EMAIL PROTECTED] Enviado el: miƩ 14/04/2004 15:40 Para: OJB Users List CC: Asunto: RE: Select MAX Hi Carles, Report Queries ret

RE: Select MAX

2004-04-14 Thread Gelhar, Wallace Joseph
Hi Carles, Report Queries return an Iterator of Object[] Object[] objs = iter2.next(); Integer max = objs[0]; Hope this helps, Wally -Original Message- From: Carles Duque [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 7:54 AM To: [EMAIL PROTECTED] Subject: Select MAX I

Select MAX

2004-04-14 Thread Carles Duque
I have a problem with this type of select. This is my code: ** Criteria crit =3D new Criteria(); org.apache.ojb.broker.query.ReportQueryByCriteria query =3D new = ReportQueryByCriteria(Estudiant.class, crit); query.setColumns(new String[] { "MAX(ID)" }); Iterator iter2 =3D broker.getRep