Take a look at the methods setStartAtIndex and setEndAtIndex as defined in the org.apache.ojb.broker.query.Query interface. I believe this is what you're looking for.
Ron Gallagher Atlanta, GA [EMAIL PROTECTED] > > From: "Lopez Vellon, Ignacio" <[EMAIL PROTECTED]> > Date: 2003/07/16 Wed PM 12:35:43 EDT > To: <[EMAIL PROTECTED]> > Subject: complex SQL > > I am using OJB for a month without any problem , but today i wanted execute > something like > this : > > select * FROM > > (SELECT rownum numFile, A0.MS_NB_USUARIO_ALTA > FROM OPENCOWNER.CRM_V_EXPEDIENTE A0 > WHERE A0.MS_NB_USUARIO_ALTA = '1') > > WHERE numFile >= '5' AND numFile <= '15' > > and i do not know how do it, i read the documentation and I did not find a solution > > I am using Oracle 9i database . > > does anyone know how to do it ? > > thank you. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
