If you are editing text directly in the database instead of on a Web form, then I agree that you might be better off storing the line breaks as <br> characters so you can see them. This assumes that the text is primarily used for display as HTML.
In general I like storing the original text. If the text doesn't get updated frequently and the HTML is displayed a lot, I store a second copy converted to HTML at the time of editing. When editing, the original text is used. When displaying in HTML, the HTML version is used. That said, if you are maintaining the text directly in the database, which is the assumption I am making, then storing two copies of the same content isn't a good idea because you would have to manually maintain both copies. -Mike Chabot On Fri, Jul 23, 2010 at 6:51 PM, Ben Conner <b...@webworldinc.com> wrote: > > Hi, > > I have a products table where the descriptions came from an outside > source. These need to be manually updated at times and I'm seeing a > difference between what gets returned by a SQL like '%xxx%' phrase vs a > REPLACE(...) phrase. The two don't always match. > > The display of the description in this store's logic uses the following: > > Replace(JSStringFormat(LongDesc),"\r\n","<br>","ALL") > > I'm just wondering out loud if it might be more expedient to store the > text descriptions with <br> statements vs the cr/lf combination. At > least then I could SEE the dang things and not wonder if I've missed a > space or something... > > Suggestions? > > Thanks! > > --Ben > > -- > Ben Conner ...@webworldinc.com > Web World, Inc. 888-206-6486 > PO Box 1122 480-704-2000 > Quee ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335689 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm