RE: CFMAIL and hair loss? - spoke too soon

[Aidan Whitehall]

Is there a limit to the amount of text you can write in an HTML e-mail sent
using CFMAIL?

variables.Invoice forms the body of the e-mail. If it goes beyond about 990
bytes, you get the e-mail, but it's blank. Less than that and the e-mail is
fine. And if you output the e-mails to the screen, they are OK.

Any ideas?


The flow is this...

CFQUERY builds a list of customers
Loop through the query
For each iteration, run CF_Invoice for that customer
CF_Invoice finds out what they should be billed and calls CF_GenerateInvoice
CF_GenerateInvoice builds a webpage, "variables.Invoice", returning it to
CF_Invoice
CF_Invoice sends an HTML e-mail with the "variables.Invoice" as the body


We've tried using different mail servers and making sure the initial query
only returns one record so the loop is only run once, always with the same
result.


BTW, if it's a bug, who should be told?



Thanks for any advice

-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFMAIL and hair loss?

[Aidan Whitehall]

Solved.



-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFMAIL and hair loss

[Aidan Whitehall]

I'm having problems building an HTML e-mail in one template and passing it
back as a variable to the calling template to then send it.

The GenerateInvoice tag builds the Invoice as a webpage, ready to send with
CFMAIL and TYPE="HTML". That bit works fine. If you output
#variables.Invoice# to the page, you get a page that displays as expected
and that HTMLValidator says is OK.



#variables.Invoice#

Running the template produces a blank HTML e-mail which (if you do View
Source in Outlook) appears to have no content. The To, From and Subject
Fields are fine.

If you delete TYPE="HTML" and set variable.Invoice in GenerateInvoice to any
old rubbish, it works fine.

Does anyone have any ideas what might be happening? GenerateInvoice is
below...


Thanks if you can offer any advice.



GenerateInvoice.cfm








   SELECT Invoices.Company,
  Invoices.CustomerID,
  Invoices.Customer,
  Invoices.InvoiceDate
 FROM Invoices
WHERE Invoices.InvoiceID = #attributes.InvoiceID#;




   
  SELECT Customers.ClientUID
FROM Customers
   WHERE Customers.CustomerID = #GetInvoice.CustomerID#;
   




   SELECT InvoiceItems.*
 FROM InvoiceItems
WHERE InvoiceItems.InvoiceID = #attributes.InvoiceID#;

















Invoice">


Invoice">
From" &
Replace(GetInvoice.Company, request.CrLf, "", "all") & "">
To" &
Replace(GetInvoice.Customer, request.CrLf, "", "all") & "">
Invoice No: " &
attributes.InvoiceID & "">
Customer No: " &
GetClientUID.ClientUID & "">


DetailsNet AmountVAT
Amount">


   " &
InvoiceItem>
   
   
  From: " &
DateFormat(PeriodFrom, "dd/mm/") & " To: " & DateFormat(PeriodTo,
"dd/mm/")>
   
   ">
   " &
DecimalFormat(NetAmount) & "">
   " &
DecimalFormat(VATAmount) & "">

   
   



">
 Total Net" &
DecimalFormat(variables.TotalNet) & "">
 Total VAT" &
DecimalFormat(variables.TotalVAT) & "">
">
 Invoice Total" &
DecimalFormat(variables.TotalNet) & "">
">

">












-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists