escaping special characters for send_email

November 25, 200817 yr

Hi,

I'm essentially using the configuration described on the following web page to send emails via XSL from the server (FMS9A).

http://www.grahamsprague.com/server_side_email/server_side_email.html

In short, the user clicks a button to run a script. The script creates a record in an "Email" table containing the email fields. It then opens the web address to the XSL (send_email.xsl, attached), which attempts to send the email.

It works fine, except when one of the email fields contains a special character (for example, an ampersand in the Subject). In that case, I get error 10202 ("Message SMTP fields error") from the send_email() function.

Do I need to translate special characters in my script, or in my XSL? I read the following thread:

http://fmforums.com/forum/showtopic.php?tid/193094/post/280665/

But to be honest, I'm not sure how it applies in this case as I'm not using Fusion Charts or anything like that.

send_email_xsl.zip