[SOLVED]500 Internal Server Error

[eluser]rogierb[/eluser]
Your select is getting escaped automatically

Code:

$this->db->select("so_id as pkey, so_no, DATE_FORMAT(so_date,'%b %d, %Y'), e.data_display as type, b.customer_name, emp_name, net, ar_so.contact, k.data_display as status");

Just add 'false' as the second param and you should be good to go

Code:

$this->db->select("so_id as pkey, so_no, DATE_FORMAT(so_date,'%b %d, %Y'), e.data_display as type, b.customer_name, emp_name, net, ar_so.contact, k.data_display as status", false);