NO... do not put the <br> tags in the database. Store the text in the database exactly as it was entered in the form. You will only need to replace carriage returns with br tags when displaying the text in an html fashion to the users. (meaning, you dont have to do it to disaply it correctly in a form field.)
If you put the br tags in the database, you will have to replace those with carriage returns to keep the br html tags from showing up in a textarea when you try to edit the text. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Webmaster at FastTrack On Line [mailto:[EMAIL PROTECTED] Sent: Monday, October 10, 2005 1:29 PM To: CF-Talk Subject: Re: Carriage returns Hi Matthew, I do that when processing the text area input field before storing it in ms sql ? Thanks, Jenny ----- Original Message ----- From: "Matthew Small" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Monday, October 10, 2005 2:22 PM Subject: RE: Carriage returns > Replace the carriage returns with "<BR>". > > > > Matthew Small > Web Developer > American City Business Journals > 704-973-1045 > [EMAIL PROTECTED] > > > -----Original Message----- > From: Webmaster at FastTrack On Line > [mailto:[EMAIL PROTECTED] > Sent: Monday, October 10, 2005 9:19 AM > To: CF-Talk > Subject: Carriage returns > > I'm using a form text area inout to store data into an ms sql nvartext > field. > > My problem is that when the field is displayed all of the carriage returns > are lost and it ends up one big blob of hard to read text. Is there some > way I can format so that the carriage returns work, please? > > Jenny > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220611 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
