RE: Limit keyword not supported in MS-SQL
| From: | YC Nyon | Date: | Sun, 21 Sep 2003 02:39:45 +0000 |
| Subject: | RE: Limit keyword not supported in MS-SQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-163330@lists.php.net to get a copy of this message | ||
I can connect to MS-SQL via php. However, the LIMIT keyword is not
supported. Looking
at the archieves, SELECT TOP X was recommended. Works ok, however i need to
specify a start row, ie. Page 1, Page 2.
Any ideas?
Nyon
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.509 / Virus Database: 306 - Release Date: 12/08/2003