Amit,

One approach is to design your query in such a way
that it returns a limited number of rows every time.
Other approach is to fetch all the records in one shot
and then store the list in a session but this is a bad
way ( session gets overloaded and data cannot be
refreshed )
you can design your query in such a way ...

 select tableA.column1, ...
 from tableA
 where column1 between 10 and 20

cheers,
Bipin

--- amit singh <amit_cbz@h...> wrote:
> Hi,
> i am fetching records by executing query,and it
> gives 1800 records in a 
> single time,i am showing these records by generating
> dynamic html page at 
> server and then call that page thru
> 'response.sendredirect'.
> i want to show limited records at a single page
> using 'previous' 
> and 'next' action .
> how can i do that in jsp?
> 
> amit singh


__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com