Re: Limiting a number of rows returned

2003-02-28 Thread Jakob Braeuchi
: Scott Howlett [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 10:30 PM To: OJB Users List Subject: RE: Limiting a number of rows returned I implemented this functionality for PostgreSQL. I subclassed SqlGeneratorDefaultImpl to provide the functionality and then pointed to my subclass

RE: Limiting a number of rows returned

2003-02-27 Thread Max Vesely
, 2003 10:30 PM To: OJB Users List Subject: RE: Limiting a number of rows returned I implemented this functionality for PostgreSQL. I subclassed SqlGeneratorDefaultImpl to provide the functionality and then pointed to my subclass in OJB.properties. My OJB.properties entry is: SqlGeneratorClass

AW: Limiting a number of rows returned

2003-02-27 Thread Geigl Maximilian, R235
uar 2003 04:27 > An: [EMAIL PROTECTED] > Betreff: Limiting a number of rows returned > > > Hi, > >Does anyone know how to limit a number of rows returned > from database > using OJB? > > Most of the database engines implement custom keywords to >

RE: Limiting a number of rows returned

2003-02-26 Thread Scott Howlett
tIndex; } return stmt; } } Hope that helps, Scott Howlett -Original Message- From: Max Vesely [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 10:27 PM To: [EMAIL PROTECTED] Subject: Limiting a number of rows returned Hi, Does anyone know how to

Limiting a number of rows returned

2003-02-26 Thread Max Vesely
Hi, Does anyone know how to limit a number of rows returned from database using OJB? Most of the database engines implement custom keywords to limit a number of rows for select statement (top, limit, rownum () < .), OJB Query interface has methods in it to set EndAt and StartAt indexes