MDB MSSQL and LIMIT
| From: | Vincent DUPONT | Date: | Tue, 20 Jul 2004 12:30:46 +0000 |
| Subject: | MDB MSSQL and LIMIT | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-13769@lists.php.net to get a copy of this message | ||
Hi,
We try to implement a MDB + Pager pagination tool as provided at :
<http://seagull.phpkitchen.com/docs/wakka.php?wakka=PagingRecordsets>
http://seagull.phpkitchen.com/docs/wakka.php?wakka=PagingRecordsets
This uses the PEAR::Pager package and performs a LIMIT (from, count) on the query so as to get only
the data that should be displayed on every page.
This works very well under Oracle 8 and 9, but we have troubble with MSSQL 8 : The number of data
displayed on every page increases on each next page.
If we set a perPage value of 5, the first page will display item 0 to 5, the second page will
display item 0-10, the third page item 0-15. So it seems the 'from' of the LIMIT
instruction is not used.
This is strange as we did not change anything on that class, that uses MDB and the behaviour is very
good under Oracle.
Is there comething weird with MDB, or with the MSSQL driver??
Any idea is welcome
Vincent