CI or MySQL bug?

[eluser]Einspruch[/eluser]
This code in my model works:

Code:

SUM(Billing.gross_amt) AS gross_revenue

but when I try to round the result to just two decimals using

Code:

ROUND(SUM(Billing.gross_amt),2) AS gross_revenue

I get this error:

Unknown column '2' in 'field list'

Any ideas as to what I am doing incorrectly? Is this a MySQL syntax issue or a CI issue?

Thanks!

Robert

[eluser]danmontgomery[/eluser]
http://ellislab.com/codeigniter/user-gui...ecord.html

$this->db->select() accepts an optional second parameter. If you set it to FALSE, CodeIgniter will not try to protect your field or table names with backticks. This is useful if you need a compound select statement.

Code:

$this->db->select('ROUND(SUM(Billing.gross_amt),2) AS gross_revenue', FALSE);

[eluser]Einspruch[/eluser]
THANK YOU!

[eluser]tenantfile[/eluser]
I don't know it will done work or not but round and sum are the aggregate functions.