I have a query for getting customer's name to put into an autogenerated
email:
<cfquery name="email_closure" datasource="helpdesk">
SELECT cust_f_init + cust_m_init + cust_lname AS email_address, resolution
FROM helpdeskmain
WHERE ticketid = #recordset1.ticketid#
</cfquery>
However, when I try to insert the variable as such:
<cfprocessingdirective suppresswhitespace="no">
<cfmail
subject="Helpdesk Ticket #Recordset1.TicketID# Has Been Closed"
from=" [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> "
to=" [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> "
>
I get this error message:
Attribute validation error for tag CFMAIL.
The value of the attribute to, which is currently "KAHAWKES
@rroads.med.navy.mil", is invalid.
The Error Occurred in
C:\Inetpub\wwwroot\INTRANET\HelpDesk\IRMD\email_test.cfm: line 248
246 : </cfoutput>
247 : <cfprocessingdirective suppresswhitespace="no">
248 : <cfmail
249 : subject="Helpdesk Ticket #Recordset1.TicketID# Has Been Closed"
250 : from="[EMAIL PROTECTED]"
Where am I going wrong?
Keith Hawkes
Database Administrator/Naval Hospital Roosevelt Roads
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
