I would verify in the DB that the field exists and it has valid data. If the #total# is a calculated variable, you are now showing how you are calculating it exactly.
I would begin at the Query level and work your way down. Use CFDUMP and dump the results of the Query to validate the data -----Original Message----- From: Pete [mailto:[EMAIL PROTECTED] Sent: Monday, March 05, 2007 12:26 PM To: CF-Talk Subject: totals not displaying 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> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271562 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
