Re: LIMIT in MS SQL
| From: | Manuel Lemos | Date: | Mon, 12 Mar 2001 17:58:17 +0000 |
| Subject: | Re: LIMIT in MS SQL | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-7340@lists.php.net to get a copy of this message | ||
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