Added flag to return dates as strings instead of PHP date objects. Updated db_select
diff --git a/system/database/drivers/sqlsrv/sqlsrv_driver.php b/system/database/drivers/sqlsrv/sqlsrv_driver.php
index 53d9748..25cc628 100644
--- a/system/database/drivers/sqlsrv/sqlsrv_driver.php
+++ b/system/database/drivers/sqlsrv/sqlsrv_driver.php
@@ -60,7 +60,7 @@
$this->hostname .= ','.$this->port;
}
- return @sqlsrv_connect($this->hostname, array('UID' => $this->username, 'PWD' => $this->password, 'Database' => $this->database, 'ConnectionPooling' => 0));
+ return @sqlsrv_connect($this->hostname, array('UID' => $this->username, 'PWD' => $this->password, 'Database' => $this->database, 'ConnectionPooling' => 0, 'ReturnDatesAsStrings' => 1));
}
// --------------------------------------------------------------------
@@ -78,7 +78,7 @@
$this->hostname .= ','.$this->port;
}
- return @sqlsrv_connect($this->hostname, array('UID' => $this->username, 'PWD' => $this->password, 'Database' => $this->database, 'ConnectionPooling' => 1));
+ return @sqlsrv_connect($this->hostname, array('UID' => $this->username, 'PWD' => $this->password, 'Database' => $this->database, 'ConnectionPooling' => 1, 'ReturnDatesAsStrings' => 1));
}
// --------------------------------------------------------------------
@@ -107,7 +107,7 @@
*/
function db_select()
{
- // not implemented in sqlsrv
+ return $this->_execute('USE ' . $this->database);
}
// --------------------------------------------------------------------