[charanjits]

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?