SQL Server 2012 (11.0.*) OFFSET NOT supported on mssql_driver LIMIT |
Hi,
My first post on this forum! I'm using CI + FlexiGrid + MySQL for a web app. This works very well. Now I'm converting it to use MS SQL Server 2012 and the pagination don't works anymore... After several tests I found the problem: On the sqlsrv_driver.php file, on the _limit() method, the code starts this way: PHP Code: protected function _limit($sql) But on the mssql_driver.php file this piece of code don't exists. After I copyed the piece of code to this file, my web app worked again! This is a bug or a feature? I'm on CI 3.1.4, but the files are the same on CI 3.1.7... Just my 0.02... Thank you for any advice!
Thx for reply!
I'm trying to access MS SQL from Linux, using PHP 5.6. But I didn't find the sqlsrv driver for PHP 5.6 Any advice? TIA!
My advice is to upgrade PHP ... Even 7.0 is already in security maintenance mode.
|
Welcome Guest, Not a member yet? Register Sign In |