I get "The value of the attribute query, which is currently WHAgentSales, is
invalid."
This is the loop:
<cfoutput>
<cfloop query="WHAgentSales">
<tr>
<td align="right">#WHAgentSales.Agent#</td>
<td align="right">#WHAgentSales.ciscoid#</td>
<td align="right">#WHAgentSales.SLL_ASC_ID_NO#</td>
<td
align="right">#numberformat(WHAgentSales.WHSalesCallsAnsd,"9,999")#</td>
<td align="right">#WHAgentSales.WHSalesAHT#</td>
<td
align="right">#numberformat(WHAgentSales.WHCCCallsAnsd,"9,999")#</td>
<td align="right">#WHAgentSales.WHCCAHT#</td>
<td align="right">$#numberformat(WHAgentSales.NetRevenue,"9,999")#</td>
<td align="right">$#numberformat(WHAgentSales.NetWHSales,"9,999")#</td>
<td align="right">#WHAgentSales.NetWHUnits#</td>
<td
align="right">$#numberformat(WHAgentSales.NetWHInstallSales,"9,999")#</td>
<td align="right">#WHAgentSales.NetWHInstallUnits#</td>
<td align="right">#WHAgentSales.TTLInstallSalesOps#</td>
<td align="right">#WHAgentSales.InstallPen#</td>
<td align="right">$#numberformat(WHAgentSales.NetPSSales,"9,999")#</td>
<td align="right">#WHAgentSales.NetPAUnits#</td>
<td align="right">#WHAgentSales.PAItemPen#</td>
<td align="right">#WHAgentSales.PADollarPen#</td>
</tr>
</cfloop>
</cfoutput>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348572
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm