You can limit the number of records returned by the query by using the SQL
LIMIT modifier
"select * from mytable where status = 1 limit 10;"
Consult *your* database engine for more information.
Aziz,,,
On Tue, 26 Jun 2001 19:41:45 +0800, Rajeev Rumale said:
> Hi,
>
> I have a SQL query which returns me a very large number of records. since it
> is not good to list them all I want to *page* them.( Displaying a fixed
> number of records at a time) and the more forward and back ward. Just like
> the serch engines display their results.
>
> I would like to know if there is a effecient solution for same.
>
> with regards
>
> Rajeev Rumale
> >
>
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
