MDB MSSQL and LIMIT

From: 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

« previous php.pear.general (#13769) next »