Hello.
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:
http://phpclasses.UpperDesign.com/browse.html/package/20
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.
http://phpclasses.UpperDesign.com/browse.html/package/130
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]