Ian, do you happen to be using the new CF Server 4.5 if so you might want to
look at the hot fixes on the Allaire web site. Below is an exact copy of
some of the receipts that I do for customers on one of my websites. I was
having problems like you describe a lot until I installed the CFMAIL hot fix
and now it works great on both the 4.5 and 4.0 server versions. Check it
out. Let me know if I can help any more.
Note that this is wrapped a little weird due to the constrictions of the
screen. If you copy and paste it into Studio it will probably look a bit
more normal.
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
<CFMAIL
TO="#CUSTOMER_INFO_CHECK.Email#"
FROM="[EMAIL PROTECTED]"
SUBJECT="Thank you for your order with ....."
QUERY="GET_BASKET_ITEMS">
Thank you for shopping with .....!
Order Number: #ORDER_ID#
Placed : #SaleDate#
Billing & Shipping Address
#CUSTOMER_INFO_CHECK.LastName#, #CUSTOMER_INFO_CHECK.FirstName#
#CUSTOMER_INFO_CHECK.Email#
#CUSTOMER_INFO_CHECK.Contact_Phone#
#CUSTOMER_INFO_CHECK.Address#<CFIF CUSTOMER_INFO_CHECK.ADDRESS2 GT
''>#Chr(10)##CUSTOMER_INFO_CHECK.ADDRESS2#</CFIF>
#CUSTOMER_INFO_CHECK.CITY#, #CUSTOMER_INFO_CHECK.STATE#
#CUSTOMER_INFO_CHECK.POSTALCODE#
#CUSTOMER_INFO_CHECK.COUNTRY#
Order Details:
Name Quantity Price % Discount
Total
----------------------------------------------------------------------------
-------------
<CFOUTPUT>#LJustify(ReplaceNoCase(GET_BASKET_ITEMS.ProductName, "Concierge
Commercial ", ""), 42)##RJustify(Qty, 3)##RJustify(DollarFormat(UnitPrice),
14)#<CFIF VolumePercent GT 0 AND QTY GTE VolumeNumber><CFSET PERCENT_OFF =
#VolumePercent#><CFELSE><CFSET PERCENT_OFF =
"N/A"></CFIF>#RJustify(PERCENT_OFF, 13)#<CFIF IsNumeric(PERCENT_OFF)><CFSET
TOTAL_PERCENT_OFF = #VolumePercent#/100 * #UnitPrice# * #QTY#><CFSET
ITEM_TOTAL = #UnitPrice# * #QTY# - #TOTAL_PERCENT_OFF#><CFSET PERCENT_OFF =
""><CFELSE><CFSET ITEM_TOTAL = #QTY# *
#UnitPrice#></CFIF>#RJustify(DollarFormat(ITEM_TOTAL), 17)#<CFSET SUB_TOTAL
= #SUB_TOTAL# + #ITEM_TOTAL#>
</CFOUTPUT>
----------------------------------------------------------------------------
-------------
#RJustify("Sub Total:", 77)##RJustify(DollarFormat(SUB_TOTAL), 12)#
<CFIF IS_TAXABLE.RECORDCOUNT IS 1><CFSET Tax = (#IS_TAXABLE.TaxRate#/1000) *
#SUB_TOTAL#><CFELSEIF IS_TAXABLE.RECORDCOUNT IS 0><CFSET Tax =
0></CFIF>#RJustify("Tax:", 77)##RJustify(DollarFormat(TAX), 12)#
#RJustify("Shipping:", 77)##RJustify(DollarFormat(SESSION.SHIPPING),
12)#<CFSET TOTAL = #SUB_TOTAL# + #TAX# + #SESSION.SHIPPING#>
#RJustify("Total:", 77)##RJustify(DollarFormat(Total), 12)#
</CFMAIL>
</CFIF>
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
Bill Killillay
ICQ @ 8425781
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
"An investment in Knowledge always pays the best interest."
-Benjamin Franklin-
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
Get Paid to Surf the Web. It's free, easy and fun.
Sign up for AllAdvantage.com at
http://alladvantage.com/go.asp?refid=FIB-034
Most of us are on it every day all day anyway, why not give
yourself a pay raise for 25 hours a month.
> -----Original Message-----
> From: Ian [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, April 09, 2000 8:09 PM
> To: [EMAIL PROTECTED]
> Subject: Cf-Mail formatting
>
>
> Thanks for the advice Joy.
>
> However, I am still having the same problem. Even though I don't
> have Query=
> in the CFMAIL tag, I am getting an error saying that a CFMAIL tag which
> contains a Query attribute cannot contain a CFOUTPUT tag which
> also contains a
> QUERY attribute.
>
> This is getting absurd. Surely someone has used CFMAIL to send
> order receipts
> to customers?
>
> Ian
>
> ____________________________________________________________________
> 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_tal
> k 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.
