Kim Hoopingarner wrote: > using the FCKEditor, I see <br /> being put into my database when storing the > editor's output. When I go to select it out of MYSQL, the <br /> is missing > from the string therefore causing the web page formats to be wrong. > > Does anyone know how to correct this? > > Well, there's a few things going on: 1) Page opens with FCKEditor 2) Content is typed/pasted in 3) Form containing FCKEditor is submitted to another script, where the content is handled somehow (assuming it's tossed into MySQL) 4) Later, another page tries to pull content out of MySQL and do something with it, I assume this is where you're having trouble.
Try throwing some debuggy-style steps in there - like, on the script in #3, before you write the content to your DB, output the textual content in a separate textarea tag, so you can see the raw code. Are the break tags where they should be before inserting the content into your database? Right after inserting into your database, do another query to pull that same content from the database, and output THAT in another textarea, like the first one. Are the break tags where they should be in THAT content? Obviously you'll want to do a cfabort after all this, so your page doesn't continue onto the next page and you don't get to see your content. If the first textarea output shows your break tags fine, and the second doesn't, then the issue isn't with FCKEditor - its somewhere else. Also - are you having trouble with ONLY <br /> tags? Meaning, if you put in old-school <br> tags, do those go through fine? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290008 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
