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! |
Messages In This Thread |
SQL Server 2012 (11.0.*) OFFSET NOT supported on mssql_driver LIMIT - by FlavioSuar - 01-22-2018, 09:57 AM
RE: SQL Server 2012 (11.0.*) OFFSET NOT supported on mssql_driver LIMIT - by Narf - 01-26-2018, 08:18 PM
RE: SQL Server 2012 (11.0.*) OFFSET NOT supported on mssql_driver LIMIT - by FlavioSuar - 01-29-2018, 05:03 AM
RE: SQL Server 2012 (11.0.*) OFFSET NOT supported on mssql_driver LIMIT - by Narf - 01-29-2018, 07:16 AM
RE: SQL Server 2012 (11.0.*) OFFSET NOT supported on mssql_driver LIMIT - by FlavioSuar - 01-29-2018, 07:47 AM
|