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

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

RE: Select MAX

2004-04-14 Thread Carles Duque
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 return an Iterator of Object