On Tuesday 05 August 2003 23:22, Jim Lucas wrote:
> also, I just noticed that you are using double quotes in your statement. I
> have always had bad luck with using double quotes. I would switch to
> single quotes.
His sql statement assignment looks fine to me. Whether you mainly use
single-qu
What are you expecting back from the sql statement?
And what are you getting?
>From what I can tell, if you are getting all your amounts from the select
statement then you are already totalling them up inside the select
statements by using the sum() function call.
if you are wanting, or expectin
Mike Fifield wrote:
> I am using the mysql sum() function to return the "sum" of a bunch of dolor
> amounts stored "float" values. But what I get back it something like this
> "98.18855591" it is to precise. All I want is the dolor amounts added up
> and rounded up to the closest penny. Is th
3 matches
Mail list logo
