Field Name Problem In CI3 |
11-26-2014, 10:16 AM
(This post was last modified: 11-26-2014, 06:09 PM by mertdogan. Edit Reason: remote quotes )
Exquise me; it is my mistake. $this->db->query("SELECT [ID] FROM table"); not generates error message.
PHP Code: $res=$this->db->select('[ID],[A],[B]')->FROM('DBTABLE')->GET()->RESULT(); is generating this field name error. This code hasn't generating error CI2. But after upgrade CI3 this model is generating error. I think this is a query escaping problem. Because when i will change my code to PHP Code: $res=$this->db->select('[ID],[A],[B]',false)->FROM('DBTABLE')->GET()->RESULT(); it isn't generating error message again. Because escaped select function resulting SELECT "[ID]","[A]","[B]" FROM "DBTABLE" This result is about table names too. In CI2; bracketed table names and select column hasn't problem but this occured in CI3. I think function has to remove brackets before escaping them. In CI2 PHP Code: $res=$this->db->select('[ID],[A],[B]',false)->FROM('[DBTABLE]')->GET()->RESULT();
I'm a person from Turkiye. I don't know English very well and i can't write what i want to say sometimes (as now happenes ).
If i write something by mistake; please don't distress it and try to understand what i want to write. |
Messages In This Thread |
Field Name Problem In CI3 - by mertdogan - 11-24-2014, 02:39 PM
RE: Field Name Problem In CI3 - by Rufnex - 11-24-2014, 03:24 PM
RE: Field Name Problem In CI3 - by slax0r - 11-25-2014, 01:23 AM
RE: Field Name Problem In CI3 - by Narf - 11-25-2014, 01:35 AM
RE: Field Name Problem In CI3 - by mertdogan - 11-26-2014, 10:16 AM
RE: Field Name Problem In CI3 - by caju - 11-30-2014, 07:29 PM
|