View Single Post

   
  #5 (permalink)  
Old 04-19-2008, 06:32 PM
KalpanaPai
 
Posts: n/a
Default Re: How to retrieve first 50 rows , next 50 rows and so on in Informix

Java , java script, JSP , HTML and Webserver is Tomcat

Thanks Heaps!!!!

John Carlson <john_carlson@whsmithusa.com> wrote in message news:<a7omkvoiah2g6amjo03s21rl8d29gccc8p@4ax.com>. ..
> On 25 Aug 2003 14:27:45 -0700, kalpanapai@hotmail.com (KalpanaPai)
> wrote:
>
> >I know that
> >Select first 50* from Table will get only 50 rows
> >But i want to know from the application side , if the query returns
> >more rows , i want to get them in 50's and display and next 50 etc, in
> >that way the query will not kill the memory if more sessions are
> >connected without bringing the whole data to the buffer .
> >

>
> What application / development language are you using?

Reply With Quote