CodeIgniter Forums
Query escaping not working, or am I doing it wrong? - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Query escaping not working, or am I doing it wrong? (/showthread.php?tid=45975)



Query escaping not working, or am I doing it wrong? - El Forum - 10-13-2011

[eluser]Unknown[/eluser]
I'm trying the following query:
Code:
$this->db->select('ROUND(SUM(amount) / 100, 2) as amount', FALSE);
but it comes out as
Code:
ROUND(SUM(amount) / 100, `2)` as amount
I tried spaces, quotes, backticks, pulling my hair out, but I can't get it to work.

To solve, I think I could write this part as plain SQL. But this is part of a bigger query. Can I combine CI-based query ($this->db->select_sum('payers')Wink with that? Thanks in advance!