am i correct to assume you are trying to display your text in a textarea? if it is not an FCKEditor-enabled text area, then it will not render your <br />... you will have to replace all <br /> with #chr(13)# (or is it #chr(10)#? or both?... can't remember right now - too early in the morning here...) to show correct linebreaks
hth Azadi Kim Hoopingarner wrote: > I am using MySql and I store the results of FCKEditor in a varchar. There > are <br /> therefore seen in the actual database field. > > However, when I go to retrieve the varchar and display it, the <br /> > disappears and causes the formatting to be off. > > What can I do to preserve the <br /> in my select statement? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290022 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
