Welcome Guest, Not a member yet? Register   Sign In
Search Results
    Thread: Query builder subquery added multiple quotes if select more than 1 column
Post: RE: Query builder subquery added multiple quotes i...

php_rocs Wrote: (06-14-2019, 07:40 AM) -- nata Wrote: (06-13-2019, 11:18 PM) -- php_rocs Wrote: (06-13-2019, 11:06 PM) -- @nata, Have you tried it with single quotes? To see if it makes a differ...
16,261 Views
10 Replies
06-14-2019, 03:29 PM
nata
    Thread: Query builder subquery added multiple quotes if select more than 1 column
Post: RE: Query builder subquery added multiple quotes i...

hc-innov Wrote: (06-14-2019, 02:46 AM) -- 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...
16,261 Views
10 Replies
06-14-2019, 03:25 PM
nata
    Thread: Query builder subquery added multiple quotes if select more than 1 column
Post: RE: Query builder subquery added multiple quotes i...

php_rocs Wrote: (06-13-2019, 11:06 PM) -- @nata, Have you tried it with single quotes? To see if it makes a difference? Also, have you tried making the query a view in the database and then cal...
16,261 Views
10 Replies
06-13-2019, 11:18 PM
nata
    Thread: Query builder subquery added multiple quotes if select more than 1 column
Post: RE: Query builder subquery added multiple quotes i...

php_rocs Wrote: (06-13-2019, 08:01 PM) -- @nata, if none of the suggested solutions are what you wish to use then my next recommendation is to troubleshoot the query to find out exactly where the ...
16,261 Views
10 Replies
06-13-2019, 08:30 PM
nata
    Thread: Query builder subquery added multiple quotes if select more than 1 column
Post: RE: Query builder subquery added multiple quotes i...

Hi, thanks for the answer @php_roccs, Yes, I am receiving errors about the above subquery. First, I don't want use $this->db->query(); Second, it is possible to do. In this case, I want to ...
16,261 Views
10 Replies
06-13-2019, 05:57 PM
nata
    Thread: Query builder subquery added multiple quotes if select more than 1 column
Post: Query builder subquery added multiple quotes if se...

Hi, I use PostgressĀ with Codeigniter V.3.1.10 I try to add subquery like this: Code: -- $this->db->select("pendaftaran_id, pendaftaran_tanggal"); $this->db->join("t_pendaftaran", "t_pendaftar...
16,261 Views
10 Replies
06-12-2019, 09:03 PM
nata

Theme © iAndrew 2016 - Forum software by © MyBB