yeh that just did what was already there...
still need help..
VTodd :: 962
STetreault :: 342
RDoe :: 839
ASchmit :: 379
TotalLeads
379 758 1137 1516
379 379 379 379
962 962 962 962
1516
<!--This loops and ADDS the FIRST value as many times as in -->
<cfset sumTotal = 0>
<cfloop query="get_leads">
<cfoutput>
<CFSET sumTotal = #sumTotal# + #get_leads.total#>
#sumTotal#
</cfoutput>
</cfloop>
<br>
<!--This loops the LAST value as many times as in -->
<cfloop query="get_leads">
<cfoutput>#get_leads.total# </cfoutput>
</cfloop>
<br>
<!--This loops the FIRST value as many times as in -->
<cfquery datasource="#request.dsn#" name="get_leadsTotal">
Select SUM(total) AS TotalLeads
From (
Select Count(*) AS total
From Leads
WHERE rep_assigned = #get_SalesAssign.usr_id#
) Leads
</cfquery>
<cfloop query="get_leads">
<cfloop query="get_leadsTotal">
<cfoutput><strong>#Get_leadsTotal["totalLeads"][currentrow]#</strong>
</cfoutput>
</cfloop></cfloop>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295881
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
