Send and retrieve HTML code to/from SQL Server

[pope on acid]

I need a solution for the following:

I have a flashform with several cftextarea's to INSERT a record and an output
PDF file to retrieve a record.

Problem: html-tags like <br> changes to a musical note on INSERT and any
output except cftextarea ignores the tags so all the content is 'inline' (no
linebreaks).

Is it possible on INSERT to bring HTML-tags to a string? eg.
firstline<br>secondline.

[JMGibson3]

You can use the replace function to change the CR's or LF's to <br>. They are
ASCII chars, CHR(10) and CHR(13) although I can never remember which is which,
example:
<cfset myText = Replace(myText,chr(10),"<br>","ALL")>
Most people do this on the way OUT of the DB whenever the destination is other
than a textarea. Thus you can continue to use the textatrea's for updating.
There is no HTML equivalent for TAB's, chr(09). You could change them to 4
nbsp's.