Logging emails

Get Started
1

Hi when I send an email through coldfusion, I want to be able to log it
Im getting the following info from queries I run


<cfmail query="Getemails"
   from="#Company_Email#"
   to="#Customer_Email#"
   subject="#COMPANY_Name#     Invoice Number: #INVOICE_Number#"
   replyto="#Company_Email#">

and using that info im trying to log it in a table called INVOICEEMAILLOG


<cfquery name="qaddintolog" datasource="#request.dsn#">
insert into INVOICEEMAILLOG
(INVOICEEMAILLOG_To,INVOICEEMAILLOG_Replyto,INVOICE_Key,INVOICEEMAILLOG_Type)
values
("#Company_Email#","#Customer_Email#","#INVOICE_Key#","#form.type#")
</cfquery>

I doesnt seem to like the above, can anyone advise what I should be doing?
Thanks

2

try it with single quotes instead of doublequotes around the string values in the VALUES clause of the query

3

Thanks R937