Hi there
I have a simple query (shown below) and also some code to display the
results. What I am hoping to display is some running totals for each site
plus a grand total for all sites. Unfortunately I am not getting any totals
displayed.
Just wondering if anyone can suggest how I get totals to display.
Many thanks in advance
<cfquery name="qGetInfo" DATASOURCE="wastemgmtaudit">
SELECT *
FROM visaudactweight v, sites s
WHERE v.siteid = s.siteid
ORDER BY s.siteid
</query>
<cfoutput query="qGetInfo" group="sitename">
<span class="introheading">State: #qGetInfo.sitename#</span><br />
<br />
<table width="95%" style="border-top: 1px solid ##000066;
border-right: 1px solid ##000066; border-bottom: 1px solid ##000066;
border-left: 1px solid ##000066;" border="0" cellpadding="4" cellspacing="0"
align="center" class="report">
<tr>
<th align="left">Site</th>
<th align="left"> </th>
<th align="left">Act Weight</th>
<th align="left"> </th>
<th align="left"> </th>
</tr>
<cfoutput>
<tr<cfif currentrow mod 2> class="alt"</cfif>>
<td align="left" width="20%"><span
class="reporttext">#qGetInfo.sitename#</span></td>
<td align="left" width="30%"><span
class="reporttext"> </span></td>
<td align="left" width="15%"><span
class="reporttext">#total#</span></td>
<td align="left" width="15%"><span
class="reporttext"> </span></td>
<td align="left" width="20%"><span
class="reporttext"> </span></td>
</tr>
</cfoutput>
</table>
<br />
</cfoutput>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271559
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
