• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SQLSRV Driver issue in v3.0.0 when upgrading from v2.2.2

Hi Support,

I have the following code using sqlsrv driver for DB connection to MS SQL Server:

$query = $this->db->select("{$this->tables['users']}.user_id,
->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'


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 Sad

Could anyone please help?

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.