Hi All,
I'm trying to loop through a query to add all the items contained in
that query.
This query set contains three records. When I do a CFOUTPUT inside the
CFLOOP on the ItemPrice field, all three individual prices are returned
in succession, but the <CFSET SubTotalTaxable> tag only shows the first
record. I want the tag to contain the sum of all three ItemPrice
fields. What am I doing wrong?
<cfset SubTotalTaxable = 0>
<!--- Loop the taxable products --->
<CFLOOP QUERY="taxableOrderItems">
<CFSET SubTotalTaxable = #OrderTotal# + #ItemPrice#>
</CFLOOP>
Thanks,
Mark
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
