Welcome Guest, Not a member yet? Register   Sign In
Field Name Problem In CI3
#5

(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(); 
hasn't problem but after CI3 upgrade they are problem for query now.
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  Blush ).

If i write something by mistake; please don't distress it and try to understand what i want to write.
Reply


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



Theme © iAndrew 2016 - Forum software by © MyBB