• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Round brackets issue in Codeigniter

#1
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

#2
And what do get doing it this way?

PHP Code:
$this->db->_protect_identifiers false;

$query $this->db->where('company_id'$this->company_idFALSE)
 
   ->get('tb_card')
 
   ->row_array(); 

Do you get the same output?

If so you could use the database query method and build your own sql select statement.
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


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