I'm in total agreement that you COULD do that but I'd recommend not. It's been my experience that putting the data into the database in the same exact format that it was entered by the user and formatting it only for display purposes (that dont affect the data directly) is your best bet to avoid trouble down the road.
You could format it with a SELECT statement though if thats what Andy meant? That would not affect the data but format it for display. -----Original Message----- From: Andrew Tyrone [mailto:[EMAIL PROTECTED] Sent: Friday, October 20, 2006 12:29 PM To: CF-Talk Subject: RE: Best way to insert text as html, without a text editor > What's the simplest way to maintain simple formatted text in > a db, without using tinyMCE, FCKeditor, or typing html into > the textarea? When I say simple, I mean I just want to show > line breaks, carriage returns, etc. Not worried about > boldness, tables, etc. > > I just tried using paragraphFormat() and it's using uppercase > <P>'s. YUCK! In addition to what Dan and Bobby said, you could also use functions within your database to handle replacing the CRLF's and vice-versa, depending on if you need to go back and forth between those and <br /> tags. Andy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257632 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
