Re: Pagination & MSSQL
| From: | Richard Davey | Date: | Tue, 09 Mar 2004 15:52:52 +0000 |
| Subject: | Re: Pagination & MSSQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-179901@lists.php.net to get a copy of this message | ||
Hello Alex,
Tuesday, March 9, 2004, 3:11:54 PM, you wrote:
AH> I have searched for some references on pagination using mssql but have come
AH> up empty.
AH> I have looked at the tutorials on Zend and just about everywhere else but
AH> unfortunately they all use LIMIT in the sql statement and the closest thing
AH> to that in mssql is either TOP n, or SET ROWCOUNT which does me no good.
This should help:
http://rosca.net/writing/articles/serverside_paging.asp
--
Best regards,
Richard Davey
http://www.phpcommunity.org/wiki/296.html