Thanks for the suggestions.
Here is what happens:
If I put the Query attribute in the CFOUTPUT tag and remove it completely from
CFMAIL, I get an error message that I am nesting queries which I can't do
because only the top level can specify the query name. Since I am not even
using the query attribute in CFMAIL this doesn't make sense.
If I put the query attribute in a CFLOOP tag I get an error message that I
have tried to use CFOUTPUT without a query attribute.
Ian
<CFMAIL
TO="#Client.email#"
FROM="[EMAIL PROTECTED]"
SUBJECT="Your latest Order">
THIS SITE IS NOT LIVE. THE ORDER YOU PLACED WILL NOT BE PROCESSED.
<CFLOOP QUERY="getCompleteOrder">
<CFOUTPUT QUERY="getCompleteOrder">
Item Qty Net Price
-----------------------------------------------------------
#LJustify(Title, 40)# #RJustify(itemQuantity, 3)#
#RJustify(NumberFormat((itemPrice * itemQuantity), "999,999.99"), 6)#
</CFOUTPUT>
</CFLOOP>
<CFOUTPUT>
Subtotal:
#getCompleteOrder.netCost#
Tax: #getCompleteOrder.tax#
Shipping: #getCompleteOrder.shipping#
-------------------------------------
Total: #total#
</CFOUTPUT>
</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.
