Formatting output from SQL Server TEXT datatype

[mikecon]

Can anyone describe methods for outputting data from a SQL Server TEXT field as it was entered? If I use

<TEXTAREA>#MyTextField#</TEXTAREA>

the text is displayed appropriately (i.e. with what appear to be CR/LFs). But if I simply

<cfoutput>#MyTextField#</cfoutput>

the line formatting is lost and I get one long, contiguous string. I tried

<cfoutput>#ParagraphFormat(MyTextField)#</cfoutput>

but that didn't work -- it just seemed to add an extra CR/LF at the end of the TEXT string. :-?

I don't want to use <TEXTAREA> because I'm looking for output-only for a printable report (in a table) and I need the entire text field displayed. (Is there a way to suppress the scroll bars and have the TEXTAREA shrink/grow to accomodate the entire text field? That would achieve the output I'm looking for)

Any ideas or experiences?

Thanx in advance!

 

[mikecon]

Since the response posts were not exactly beating down my door, I tried a bunch of things and it boils down to this. Maybe I'll get a self-inflicted 'star' ;-) ...

As I now see clearly, HTML doesn't give a rat's behind about CR/LF -- it summarily ignores them.

That's where something like <pre> comes in (although that was not a good solution for me -- to restrictive in it's lack of 'formattability').

Soon after, it dawned on me to simply replace the CR/LFs with HTML like <br> or <p>:

#REReplace(MyTextField, CHR(13) & CHR(10), &quot;<br>&quot;, &quot;ALL&quot#

 

[tleish]

I've used this tag and it worked very well for me:

CF_TEXTAREAFORMAT

http://devex.allaire.com/developer/...34743E-2830-11D4-AA9700508B94F380&method=Full

- tleish

 

[mikecon]

That would cover the rest. Thanx!

 

[mokaplanjr]

You should take a look at the ReplaceList function. You can replace any combination of characters (including hidden ones like carriage returns) with anything else. For instance, replace a carriage return with <br>.