Welcome Guest, Not a member yet? Register   Sign In
Query builder subquery added multiple quotes if select more than 1 column
#10

(06-14-2019, 02:46 AM)hc-innov Wrote: Your issue with quotes.
I think that's the normal behavior of CI $this->db->from()

Look the fille system/database/DB_query_builder ligne 478. there is an explode function in the parameter of from.
After that, you have an array:

(SELECT trx_no
pendaftaran_id FROM t_transaksi GROUP BY
trx_no
pendaftaran_id) as t_tr

line 483: each row of the array go to function protect_identifiers...: you find it in DB_driver line 1782.
In this function you find line 1833 a condition: if the string contains a parenthesis or ' return the string without quotes.

Finally, you can't get the correct query....
Sorry for late answer.
Oh yup, that's my problem.  Big Grin 

Thanks for your help.
Reply


Messages In This Thread
RE: Query builder subquery added multiple quotes if select more than 1 column - by nata - 06-14-2019, 03:25 PM



Theme © iAndrew 2016 - Forum software by © MyBB