Scott,

As far as I know, MS SQL supports a syntax like this:

SELECT TOP 10 FROM table_name WHERE etc etc

However, I don't know how to make it start from a certain offset; I guess MS
SQL's documentation, especially the T-SQL doc, should help.

""Scott Parks"" <[EMAIL PROTECTED]> a écrit dans le message news:
00b601c08ed1$ef153f30$[EMAIL PROTECTED]
> 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]

Reply via email to