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

(06-14-2019, 07:40 AM)php_rocs Wrote:
(06-13-2019, 11:18 PM)nata Wrote:
(06-13-2019, 11:06 PM)php_rocs Wrote: @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 calling the view in CI?

Already tried single quotes but same errors.

if making query create in the view then call it in CI working fine.

@nata,

Making sure I understand you.  You made the query above in PostgreSQL and saved it as a view (Get_Penda ) in the database.  You then called the view in CI like this...

PHP Code:
$this->db->select("pendaftaran_id, pendaftaran_tanggal");
$this->db->from("Get_Penda");
$q $this->db->get();
return 
$q->result_array(); 

Yes, you are right...

The problem has been found. @hc-innov already explain it.
Thanks for your help bro.  Smile
Reply




Theme © iAndrew 2016 - Forum software by © MyBB