Round brackets issue in Codeigniter |
03-10-2018, 03:40 AM
(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 |
Messages In This Thread |
Round brackets issue in Codeigniter - by kalyanbl - 03-10-2018, 03:40 AM
RE: Round brackets issue in Codeigniter - by InsiteFX - 03-10-2018, 07:38 AM
RE: Round brackets issue in Codeigniter - by jamesmillere - 01-19-2023, 12:00 AM
|