Re: only grab 10 records

2003-11-19 Thread Jakob Braeuchi
http://article.gmane.org/gmane.comp.jakarta.ojb.user/10065/match=paging+perf ormance+issues Cheers, Charles. -Original Message- From: Andy Czerwonka [mailto:[EMAIL PROTECTED] Sent: 11 November 2003 13:35 To: 'OJB Users List' Subject: only grab 10 records Does anyone know if its possible

Re: only grab 10 records

2003-11-12 Thread Jakob Braeuchi
s why, see http://article.gmane.org/gmane.comp.jakarta.ojb.user/10065/match=paging+perf ormance+issues Cheers, Charles. -Original Message- From: Andy Czerwonka [mailto:[EMAIL PROTECTED] Sent: 11 November 2003 13:35 To: 'OJB Users List' Subject: only grab 10 records Does any

Re: only grab 10 records

2003-11-12 Thread Jakob Braeuchi
well sorry, posetd without reading the whole thread :( jakob Jakob Braeuchi wrote: hi andy, have you tried using query.setStartIndex(), setEndIndex() ? it's not as elegant as paging and you also need to keep track of the index yourself. jakob Andy Czerwonka wrote: Does anyone know if its p

Re: only grab 10 records

2003-11-12 Thread Jakob Braeuchi
hi andy, have you tried using query.setStartIndex(), setEndIndex() ? it's not as elegant as paging and you also need to keep track of the index yourself. jakob Andy Czerwonka wrote: Does anyone know if its possible to do something like this in OJB: select * from table where criteria but only

Re: only grab 10 records

2003-11-11 Thread Joseph Campbell
of adding the appropriate SQL to a query... > > > > Note, this will tie your application to Oracle. > > > > Cheers, > > > > Charles. > > > > > -Original Message- > > > From: Andy Czerwonka [mailto:[EMAIL PROTECTED] > > &

Re: only grab 10 records

2003-11-11 Thread Andy Czerwonka
MAIL PROTECTED] > > Sent: 11 November 2003 14:11 > > To: OJB Users List > > Subject: Re: only grab 10 records > > > > > > Oracle 9i > > > > On November 11, 2003 6:49 am, Charles Anthony wrote: > > > Which Database ? > > > > > > &

Re: only grab 10 records

2003-11-11 Thread Andy Czerwonka
49 am, Charles Anthony wrote: > > Which Database ? > > > > > -Original Message- > > > From: Andy Czerwonka [mailto:[EMAIL PROTECTED] > > > Sent: 11 November 2003 13:55 > > > To: OJB Users List > > > Subject: Re: only grab 10 r

Re: only grab 10 records

2003-11-11 Thread Andy Czerwonka
November 11, 2003 6:49 am, Charles Anthony wrote: > Which Database ? > > > -Original Message- > > From: Andy Czerwonka [mailto:[EMAIL PROTECTED] > > Sent: 11 November 2003 13:55 > > To: OJB Users List > > Subject: Re: only grab 10 records > > > > &

RE: only grab 10 records

2003-11-11 Thread Charles Anthony
, Charles. > -Original Message- > From: Andy Czerwonka [mailto:[EMAIL PROTECTED] > Sent: 11 November 2003 14:11 > To: OJB Users List > Subject: Re: only grab 10 records > > > Oracle 9i > > On November 11, 2003 6:49 am, Charles Anthony wrote: > > Which Database ? &

Re: only grab 10 records

2003-11-11 Thread Andy Czerwonka
Oracle 9i On November 11, 2003 6:49 am, Charles Anthony wrote: > Which Database ? > > > -Original Message- > > From: Andy Czerwonka [mailto:[EMAIL PROTECTED] > > Sent: 11 November 2003 13:55 > > To: OJB Users List > > Subject: Re: only grab 10 recor

RE: only grab 10 records

2003-11-11 Thread Charles Anthony
Which Database ? > -Original Message- > From: Andy Czerwonka [mailto:[EMAIL PROTECTED] > Sent: 11 November 2003 13:55 > To: OJB Users List > Subject: Re: only grab 10 records > > > Then I have a problem. Is there a way to say 'select next > record order

Re: only grab 10 records

2003-11-11 Thread Andy Czerwonka
OJB. > > For an explanation of the reasons why, see > http://article.gmane.org/gmane.comp.jakarta.ojb.user/10065/match=paging+per >f ormance+issues > > Cheers, > > Charles. > > > -Original Message- > > From: Andy Czerwonka [mailto:[EMAIL PROTECTED] > >

RE: only grab 10 records

2003-11-11 Thread Charles Anthony
; From: Andy Czerwonka [mailto:[EMAIL PROTECTED] > Sent: 11 November 2003 13:35 > To: 'OJB Users List' > Subject: only grab 10 records > > > Does anyone know if its possible to do something like this in OJB: > > select * from table where criteria but only retur

only grab 10 records

2003-11-11 Thread Andy Czerwonka
Does anyone know if its possible to do something like this in OJB: select * from table where criteria but only return me a maximum of 10 records. Is this possible? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional comm