There are two ways. In MS SQL server 7.0 you can do SELECT TOP <#>
If you are on 6.5, then you need to do set the row count
environ variable, e.g something like "set rowcount <#>"
-Original Message-
From: disko_kex
To: [EMAIL PROTECTED]
Sent: 2003-07-02 1
PROTECTED]>
Sent: Wednesday, July 02, 2003 12:20 PM
Subject: [PHP-WIN] MSSQL HELP
: In MySQL is easy to page with LIMIT but it doesnt work with MSSQL. So
: how do I make it page in MSSQL?
:
:
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
In MySQL is easy to page with LIMIT but it doesnt work with MSSQL. So
how do I make it page in MSSQL?