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, 19 insertions, 10 deletions

diff --git a/system/database/drivers/mssql/mssql_driver.php b/system/database/drivers/mssql/mssql_driver.php
index 5ac90b451..9a912a320 100644
--- a/system/database/drivers/mssql/mssql_driver.php
+++ b/system/database/drivers/mssql/mssql_driver.php
@@ -390,7 +390,24 @@ class CI_DB_mssql_driver extends CI_DB {
 		// Are error numbers supported?

 		return '';

 	}

-	

+

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

+

+	/**

+	 * 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 MS SQL so we simply return the value

+		return $column;

+	}

+

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

 

 	/**

@@ -405,15 +422,7 @@ class CI_DB_mssql_driver extends CI_DB {
 	 */

 	function _escape_table($table)

 	{

-		// I don't believe this is necessary with MS SQL.  Not sure, though. - Rick

-	

-		/*

-		if (strpos($table, '.') !== FALSE)

-		{

-			$table = '"' . str_replace('.', '"."', $table) . '"';

-		}

-		*/

-		

+		// Not necessary with MS SQL so we simply return the value

 		return $table;

 	}