+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Development (https://forum.codeigniter.com/forumdisplay.php?fid=6)
+--- Forum: Issues (https://forum.codeigniter.com/forumdisplay.php?fid=19)
+--- Thread: SQLSRV Driver issue in v3.0.0 when upgrading from v2.2.2 (/showthread.php?tid=61665)
SQLSRV Driver issue in v3.0.0 when upgrading from v2.2.2 - charanjits - 05-05-2015
Hi Support,
I have the following code using sqlsrv driver for DB connection to MS SQL Server:
Code:
$query = $this->db->select("{$this->tables['users']}.user_id,
{$this->tables['users']}.first_name,
{$this->tables['users']}.middle_name,
{$this->tables['users']}.last_name,
{$this->tables['users']}.email")
->select("{$this->tables['roles']}.role_id,
{$this->tables['roles']}.role_name,
{$this->tables['roles']}.sort_order")
->from( $this->tables['users'] )
->join( $this->tables['roles'], "{$this->tables['users']}.role_id = {$this->tables['roles']}.role_id", 'left' )
->where( array(
"{$this->tables['users']}.email" => $username,
"{$this->tables['users']}.country_id" => $this->current_country_details['country_id'],
"{$this->tables['users']}.is_active" => '1'
))
->limit(1)
->get();Issue came after I upgraded from v2.2 to v3.0. The only change was framework upgrade, and updates as the upgrade instructions. The above mentioned code was returning a result in v2.2 but once I upgraded to v3.0 it started returning null
Could anyone please help?