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

Reply via email to