I don't have a lot of experience with the CFMAIL tag. However, I am sure
that you do not need (and I suspect can not use at all) the CFOUTPUT tag
within the CFMAIL tag. Also, for the loop, try creating a variable set to
the getCompleteOrder.RecordCount before the start of the CFMAIL. Then just
use that variable for your Loop within CFMAIL.
-Allen
----- Original Message -----
From: Ian <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 09, 2000 8:55 AM
Subject: Re: Cf-mail formatting
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?sidebar=sts&body=sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
