Added backticks to column names when using insert_string and update_string. Relates to this bug report: http://codeigniter.com/bug_tracker/bug/4509/

1 files changed, 18 insertions, 2 deletions

diff --git a/system/database/drivers/sqlite/sqlite_driver.php b/system/database/drivers/sqlite/sqlite_driver.php
index 5cac04dfa..46e0fae49 100644
--- a/system/database/drivers/sqlite/sqlite_driver.php
+++ b/system/database/drivers/sqlite/sqlite_driver.php
@@ -387,7 +387,24 @@ class CI_DB_sqlite_driver extends CI_DB {
 	{

 		return sqlite_last_error($this->conn_id);

 	}

-		

+

+	// --------------------------------------------------------------------

+

+	/**

+	 * Escape Column Name

+	 *

+	 * This function adds backticks around supplied column name

+	 *

+	 * @access	private

+	 * @param	string	the column name

+	 * @return	string

+	 */

+	function _escape_column($column)

+	{

+		// Not necessary with SQLite so we simply return the value

+		return $column;

+	}

+			

 	// --------------------------------------------------------------------

 

 	/**

@@ -402,7 +419,6 @@ class CI_DB_sqlite_driver extends CI_DB {
 	 */

 	function _escape_table($table)

 	{

-

 		// other database drivers use this to add backticks, hence this

 		// function is simply going to return the tablename for sqlite		

 		return $table;