Running CF8, MSSQL 2005

I have a question about keeping "chr(10)'s and chr(13)'s" in plain text
emails. ..and before I go on experimenting to find my answer, I figured
someone might have a quick answer here.

I am sending out an email message using cfmail. This email can be HTML or
just plain TEXT depending on the preference for a given email address.

Strictly speaking on PLAIN TEXT emails. I want to populate the body of the
email from a database.  The database would originally be populated via a
textarea in a form for the BODY of the email. So in order to have different
plain text paragraphs, it would be just double cr/lf's in the textarea.

Whats the best way to insert this textarea into the MSSQL database to retain
the CR/LF's so when I do a cfmail it will KEEP these CR/LF's and show
correctly in someones email program in PLAIN TEXT keeping the CR/LF's?

I hope that made sense to someone. :)

Thanks,
Jeff


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295137
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to