Kevin is correct, it is in most situations the best practice .. BUT, if you do a paragraphFormat on the insert, you can do a replace for <br> and <p> and replace it with chr(10) and/or chr(13) or whatever it puts in the code before they edit the data .. in some situations this is a way to get around that ----- Original Message ----- From: "Brad Roberts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, August 17, 2002 10:33 PM Subject: RE: Beginner's question - entering text with breaks
> 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 > > > > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
