EllisLab/CodeIgniter — Issue #706: Database library doesn't escape mssql queries properly.
Author: Loupax
Created: 2011-11-24 11:20:52+00:00
State: open

I'm using CodeIgniter 2.1.0 and use M$Sql for an app I work on.

I'm using a simple table named Users with only an id and name columns, and try to insert data to it using this command:

$this->db->insert('Users', array('name'=>'My Name'));

and it tries to run this query:

INSERT INTO Users (name) VALUES (My name); //Invalid object name 'Users'.

instead of this

INSERT INTO "Users" ("name") VALUES ('My name');