05-05-2015, 01:48 AM
(This post was last modified: 05-15-2015, 12:43 AM by charanjits.
Edit Reason: Added more detail as to how the error started coming
)
Hi Support,
I have the following code using sqlsrv driver for DB connection to MS SQL Server:
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?
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?