Welcome Guest, Not a member yet? Register   Sign In
Round brackets issue in Codeigniter
#1

(This post was last modified: 03-10-2018, 06:12 AM by ciadmin. Edit Reason: SEO link redacted )

Hi,

I am working on Codeigniter project, I need to migrate whole database MySQL to SQL server, for that I am getting an issue in select query, I can see in SQL server round brackets are not supported around the table name, here is my Codeigniter query

$this->db->_protect_identifiers=false;
$this->db->select('*')->from('tb_card',false);
$this->db->where('company_id',$this->company_id,FALSE)->get()->row_array();
This select query generates below query

SELECT * FROM (tb_card) WHERE company_id = 27

You can see there are round brackets around the table name, I want to remove this, can anyone please help me to resolve this issue?

Thank you
Reply


Messages In This Thread
Round brackets issue in Codeigniter - by kalyanbl - 03-10-2018, 03:40 AM



Theme © iAndrew 2016 - Forum software by © MyBB