• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Query builder subquery added multiple quotes if select more than 1 column

#11
(06-14-2019, 08:40 AM)php_rocs Wrote:
(06-14-2019, 12:18 AM)nata Wrote:
(06-14-2019, 12:06 AM)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


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.