Welcome Guest, Not a member yet? Register   Sign In
CI or MySQL bug?
#1

[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:
Quote: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


Messages In This Thread
CI or MySQL bug? - by El Forum - 05-08-2011, 10:02 PM
CI or MySQL bug? - by El Forum - 05-09-2011, 04:38 AM
CI or MySQL bug? - by El Forum - 05-09-2011, 08:27 PM
CI or MySQL bug? - by El Forum - 05-12-2011, 03:18 AM



Theme © iAndrew 2016 - Forum software by © MyBB