Re: db paging with MS Sql

I'm pretty sure there's no other way to do it but to read them all in and only display what you need. AFAIK, MSSQL doesn't support paging itself, but relies on the ADO driver to do this. If you make an reference to an ADO object in VBScript, you can set how many rows are in a 'page', then tell it to jump to a specific page, to jump to that group of rows. My terminology is probably wrong above, haven't used ADO/VBScript stuff in awhile. But that's the gist. Scott Parks 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. > > tia > > -- > 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