It must be my cfoutput...

[programmher]

I have a simple query:

<cfquery name=&quot;Tabulate&quot;>
Select Guest, Charge, Amount, Date
From InnTable
Where guest = 'jones'

</cfquery>

My result looks something like this:

Jones Cable TV 25.00 08/01/01
Jones Phone .75 08/03/01
Jones Phone .75 08/10 01

I want my result to look like this:

Jones 26.50

When I run this in query analyzer and either use a SUM or Order BY, I get my desired result.

But, when I run this from my webpage, I am unable to get my fields to sum.

I suspect something is amiss with my cfoutput. I used <cfoutput query=&quot;Tabulate&quot; group=&quot;Guest&quot;> Then I attempt to group by &quot;Charge&quot; but to no avail.

What am I missing?

 

[Silvano]

try this:


<cfquery name=&quot;Tabulate&quot;>
Select Guest, Charge, SUM(Amount) as total, Date
From InnTable
Where guest = 'jones'

</cfquery>


<cfoutput query=&quot;Tabulate&quot;>
#guest# #total#
</output> Sylvano
dsylvano@hotmail.com

&quot;every and each day when I learn something new is a small victory...&quot;

 

[programmher]

Sylvano,

Thanks a million! That worked like a charm. I actually did this before but couldn't remember exactly how I did it.

Thanks for the help!

-P