Thanks for the help Joy. Your solution combined with a little more cajolling
got it working. Here is the solution: Includ ethe query name in the CFMAIL tag
and the GROUPBY attribute for the orderID.
<CFMAIL QUERY="getCompleteOrder"
GROUP="orderID"
TO="#Client.email#"
FROM="[EMAIL PROTECTED]"
SUBJECT="Your latest Order">
ORDER NUMBER: #orderID#
Item Qty Net Price
-----------------------------------------------------------
<CFLOOP QUERY="getCompleteOrder">
#LJustify(getCompleteOrder.Title, 40)#
#RJustify(getCompleteOrder.itemQuantity, 3)#
#RJustify(NumberFormat((getCompleteOrder.itemPrice *
getCompleteOrder.itemQuantity), "999,999.99"), 6)#
</CFLOOP>
Subtotal:
#NumberFormat(getCompleteOrder.netCost, "999,999.99")#
Tax: #NumberFormat(getCompleteOrder.tax, "999,999.99")#
Shipping: #NumberFormat(getCompleteOrder.shipping, "999,999.99")#
-------------------------------------
Total: #NumberFormat(total, "999,999.99")#
</CFMAIL>
____________________________________________________________________
Get your own FREE, personal Netscape WebMail account today at
http://webmail.netscape.com.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
