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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
