I'm not clear what you are having trouble with: is it the total dollars or
the total item count?
-----Original Message-----
From: Kathy Bergman [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 06, 2000 3:40 PM
To: CF-Talk
Subject: dynamic value
I'm stumped and could sure use help! How can I get a total number of all
items ordered? The item and quantities picked of each item display, but
I've run out of ideas for outputting the total amounts. Listlen doesn't
work. Any other ideas? thanks!!!!!!
<CFLOOP LIST="#fieldnames#" INDEX="ListElement">
<cfquery name="getproducts" datasource="mydatabase">
Select Price, Prod_desc, prodcode
>From Prodcodes
Where prodcode = '#listelement#'
</cfquery>
<CFSET ThisName=Evaluate(Listelement)>
<CFSET ThisValue=Evaluate(ThisName)>
<CFSET #OrderQty# = #ThisValue#>
<CFSET #OrderSubtotal# = #getproducts.price#>
<cfset #itemsubtotal# = #thisvalue# * #Getproducts.Price#>
<cfif '#thisvalue#' neq "0">
<CFOUTPUT>
<table>
<tr>
<td valign="middle" align="left" height="30"><font
size="2">#getproducts.prod_desc#<br></font></td>
<td valign="middle" height="30" align="center"><font
size="2">#NumberFormat(Getproducts.Price,'$9(9999.99)')#</font></td>
<td valign="middle" height="30" align="center"><font
size="2">#thisvalue#</font></td>
<td valign="middle" height="30" align="center"><font
size="2">#NumberFormat(itemsubtotal,'$9(9999.99)')#</font></td>
</tr>
</table>
</CFOUTPUT>
</cfif>
</cfloop>
<cfoutput>
<tr>
<td height="11"><font size="2"><b>Subtotal</b> </font></td>
<td height="11"> </td>
<td height="11" align="center" valign="middle"><font
size="2">#itemsordered#</font></td>
<td height="11" valign="top" align="right"> <font
size="2">#NumberFormat(OrderSubTotal,'$9(9999.99)')# </font></td>
</tr>
<tr>
<td height="11"><font size="2"><b>Sales Tax</b> </font></td>
<td height="11"> </td>
<td height="11"> </td>
<td height="11" valign="top" align="right"> <font
size="2">#NumberFormat(SalesTax,'$9(9999.99)')# </font></td>
</tr>
<tr>
<td height="11"><font size="2"><b>Shipping</b> </font></td>
<td height="11"> </td>
<td height="11"> </td>
<td height="11" valign="top" align="right"> <font
size="2">#NumberFormat(Shipping,'$9(9999.99)')#</font></td>
</tr>
<tr>
<td height="11"><font size="2"><b>TOTAL</b></font></td>
<td height="11"> </td>
<td height="11" align="center" valign="middle"><font
size="2">#TotalQty#</font></td>
<td height="11" valign="middle"><p align="right"><font
size="2">#NumberFormat(OrderTotal,'$9(9999.99)')# </font></td>
</tr>
</table>
</cfoutput>
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
