I'm with you. If you use paragraphFormat() when inserting the text into the db, you'll end up with html tags in your text. Then, when someone goes back to edit the data, they'll see the tags. I think it's usually best for html tags to be transparent to the end user.
-Brad > -----Original Message----- > From: Kevin Graeme [mailto:[EMAIL PROTECTED]] > Sent: Saturday, August 17, 2002 10:30 PM > To: CF-Talk > Subject: RE: Beginner's question - entering text with breaks > > > Mind if I ask why on insert? I've always done it on output since > I prefer to > keep my database data "pure". > > -Kevin > > > -----Original Message----- > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > > Sent: Saturday, August 17, 2002 8:07 PM > > To: CF-Talk > > Subject: Re: Beginner's question - entering text with breaks > > > > > > You will want to do it when inserting... > > > > <cfquery datasource="datasource" name="insertRecord"> > > INSERT INTO table > > (id,lyrics) > > VALUES(1,'#ParagraphFormat(form.lyrics)#') > > </cfquery> > > > > Paul Giesenhagen > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
