Active Record bug sets unintended apostroph

[eluser]Jason Hamilton-Mascioli[/eluser]
Yes, try to set the select's second parameter to false (as shown in the docs) to resolve this ...

Code:

$this->db->select('(SELECT SUM(payments.amount) FROM payments WHERE payments.invoice_id=4') AS amount_paid', FALSE);
$query = $this->db->get('mytable');