Fredrik Wahlberg wrote:
> Is there any equivalent to MySQL's ?LIMIT x,y? in Microsoft SQL-Server?

You need to use server side cursors. You may want to look at how
Metabase, the PHP database abstraction package does it when using
MS-SQL. For Metabase users, it is as simple as calling the function
MetabaseSetSelectedRowRange($database,$first,$limit) before each query.

You may find Metabase here:


You may also want to try this PHP Class that displays query results in
HTML tables with links to go back and forth between pages.


Manuel Lemos

PHP Database 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