Re: limit for MSSQL
| From: | Zoltan Konyves | Date: | Fri, 11 Apr 2003 21:06:03 +0000 |
| Subject: | Re: limit for MSSQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-143576@lists.php.net to get a copy of this message | ||
Hello Foong,
Tuesday, April 8, 2003, 11:52:03 AM, you wrote:
F> Hello,
F> The following SQL does not work in MSSQL:
F> select * from table limit 20, 50
F> The TOP # in MSSQL doesn't alow me specify which starting record to
F> retrieve, only how many record to retrieve..
F> Anyone has solve this kind of problem before?
F> Foong
Try the DB module from PEAR for access databases.
--
Best regards,
Zoltan mailto:zolikonyves@home.ro