Re: db paging with MS Sql

AFAICT there is no 'LIMIT' feature in MS SQL products (TOP and supposedly BOTTOM, but BOTTOM has never worked for me and TOP doesn't seem to work on all versions). How is metabase handling this? Pulling everything, looping thru, and only returning the requested rows? Yes, I could log in/download/uncompile and spend the next 20 minutes finding it for myself, but I'm in the midst of work! ;) And getting and explanation from the horse's mouth might be more instructive anyway. !!! Manuel Lemos wrote: > Hello Scott, > > On 04-Feb-01 14:41:58, you wrote: > > >Has anyone seen a good lession or code example on paging records from MS Sql > >7? Say I have 300 records and > >want to break them down to 10 per page using [previous | next ] and a list > >of page numbers at the bottom. > > You may want to use Metabase that lets you pick the range of rows that are > returned by a SELECT query. It works not only with Microsoft SQL server > but also many other databases supported by PHP. > > http://phpclasses.UpperDesign.com/browse.html/package/20 > > You may also want to try this query result table display class that displays > select query result rows in HTML tables and may generate automatically links > to move go to the Previous, Next, First, Last or any other page of query > results. > > http://phpclasses.UpperDesign.com/browse.html/package/130 > > Regards, > Manuel Lemos > > Web Programming Components using PHP Classes. > Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org > -- > E-mail: mlemos@acm.org > URL: http://www.mlemos.e-na.net/ > PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp > -- > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net