ah! that'd do it :) I agree with Duncan, insert into the db as it's entered by the user, do what you want with it on retrieval.
----- Original Message ----- From: "Lovelock, Richard J" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 27, 2003 3:58 PM Subject: RE: [ cf-dev ] Keeping text formatting > Sorry guys - slap on the wrist - just realised what i was doing > > i have started developing this page after returning to it after several > weekes > > I was trying to get round this problem before - and one way i tried was > entering the comments text data on to the db using ParagraphFormat() > > Mr.Forta says that this converts single newline chars into spaces which is > what was happening. took that off and all ok - replace functions working > also > > thanks a lot > > _______________________________________________________ > * Regards, > Richard Lovelock > Westminster City Council - Web Support > Cap Gemini Ernst & Young > Southbank > 95 Wandsworth Road > London > SW8 2HG > ( 0870 906 7482 > > _______________________________________________________ > > > -----Original Message----- > From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] > Sent: 27 November 2003 15:47 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Keeping text formatting > > > access 2000 - field is text, length 255 > > do i have to insert it any differently in the first place given that it will > have carriage returns/line feeds (<< not sure of the difference??) ? > > _______________________________________________________ > * Regards, > Richard Lovelock > Westminster City Council - Web Support > Cap Gemini Ernst & Young > Southbank > 95 Wandsworth Road > London > SW8 2HG > ( 0870 906 7482 > > _______________________________________________________ > > > -----Original Message----- > From: Damian Watson [mailto:[EMAIL PROTECTED] > Sent: 27 November 2003 15:44 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] Keeping text formatting > > > It should still work when you pull it from the database... what db is it? > > ----- Original Message ----- > From: "Lovelock, Richard J" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, November 27, 2003 3:41 PM > Subject: RE: [ cf-dev ] Keeping text formatting > > > > Thanks Duncan > > > > Made some progress.... > > > > I wasn't actually outputting the comments from the form page - I was > > actuallly doing an insert of the comments in to the DB at the top of the > > page then pulling back the info to check that the insert worked ok. > > > > I was then using the info pulled back in the query from the DB to output > to > > the page... > > > > IF - I use the replace chr(10) etc etc straight on the form field without > > going to the DB first it works fine and my line feeds are accurate. > > > > IF - I go to the DB first - the replace chr(10) doesn't work. > > > > This would suggest that the info coming back from the DB is different from > > that which comes direct from the form. > > > > Perhaps I need to change the way this info is stored as I will be using a > > page which calls the text from the DB to display all of these comments. > > > > I am using Access 2000 and the field is defined as text, length 255?? > > > > _______________________________________________________ > > * Regards, > > Richard Lovelock > > Westminster City Council - Web Support > > Cap Gemini Ernst & Young > > Southbank > > 95 Wandsworth Road > > London > > SW8 2HG > > ( 0870 906 7482 > > > > _______________________________________________________ > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] > > Sent: 27 November 2003 15:34 > > To: [EMAIL PROTECTED] > > Subject: RE: [ cf-dev ] Keeping text formatting > > > > > > > > <cfset newcomments = ReplaceList(getcomments.comments, "#Chr(10)#,#Chr(13) > > #", "<br>")> > > > > > > Duncan Cumming > > IT Manager > > > > http://www.alienationdesign.co.uk > > mailto:[EMAIL PROTECTED] > > Tel: 0141 575 9700 > > Fax: 0141 575 9600 > > > > Creative solutions in a technical world > > > > ---------------------------------------------------------------------- > > Get your domain names online from: > > http://www.alienationdomains.co.uk > > Reseller options available! > > ---------------------------------------------------------------------- > > ---------------------------------------------------------------------- > > > > > > > > > > "Lovelock, > > > > Richard J" To: > > "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > > <richard.lovelock cc: > > > > @cgey.com> Subject: RE: [ cf-dev ] > > Keeping text formatting > > > > > > 27/11/2003 15:19 > > > > Please respond to > > > > dev > > > > > > > > > > > > > > > > > > can you put multiple replaces in the same replace function? > > > > i tried chr(10) on its own (in place of the 13) and this made no > difference > > > > you can try it in the comments box here: > > http://fclounge.cfdeveloper.co.uk/commentadd.cfm > > > > _______________________________________________________ > > * Regards, > > Richard Lovelock > > Westminster City Council - Web Support > > Cap Gemini Ernst & Young > > Southbank > > 95 Wandsworth Road > > London > > SW8 2HG > > ( 0870 906 7482 > > > > _______________________________________________________ > > > > > > -----Original Message----- > > From: Stephen Pope [mailto:[EMAIL PROTECTED] > > Sent: 27 November 2003 15:14 > > To: [EMAIL PROTECTED] > > Subject: RE: [ cf-dev ] Keeping text formatting > > > > > > You might also try #chr(10)# as well as #chr(13)# > > > > -----Original Message----- > > From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] > > Sent: 27 November 2003 15:13 > > To: '[EMAIL PROTECTED]' > > Subject: RE: [ cf-dev ] Keeping text formatting > > > > cheers Robin..... > > > > I tried: > > > > <tr class="matchtableleft"> > > <td valign="top">Comments:</td> > > > > <td>#replace("#getcomments.comments#",chr(13),"<br>","all")#</td> > > </tr> > > > > but it has made no difference?? have i got the syntax wrong? > > > > > > _______________________________________________________ > > * Regards, > > Richard Lovelock > > Westminster City Council - Web Support > > Cap Gemini Ernst & Young > > Southbank > > 95 Wandsworth Road > > London > > SW8 2HG > > ( 0870 906 7482 > > > > _______________________________________________________ > > > > > > -----Original Message----- > > From: Robin Griffiths [mailto:[EMAIL PROTECTED] > > Sent: 27 November 2003 15:05 > > To: [EMAIL PROTECTED] > > Subject: Re: [ cf-dev ] Keeping text formatting > > > > > > 2 options I can think of > > > > 1. Use <pre></pre> tags to output exactly as the user input the code. > > 2. User replace(myFieldContents,chr(13),"<br>","ALL") > > ----- Original Message ----- > > From: Lovelock, Richard J > > To: 'cflist' > > Sent: Thursday, November 27, 2003 3:02 PM > > Subject: [ cf-dev ] Keeping text formatting > > > > > > I have a form with a multi line text box. > > > > On the action page - i am trying to display the contents of the text > > box > > but > > it is not formatting the line feeds/carriage returns properly. > > > > If the user enters some text and hits enter on the text box after > > writing > > some text to start a new line and then enters more text, then the > > resultant > > action page just puts 1 space between the two blocks of text instead > > of > > starting the text on a new line. > > > > If the user enters some text then hits enter twice to effectively > > start a > > new line of text with a line of gap in between the last one - then the > > action page renders this correctly. > > > > Do I need to use a certain function to uphold the carriage returns and > > line > > feeds accurately? I had a look at HTMLEditFormat and HTMLCodeFormat > > but > > neither upholds the formatting > > > > _______________________________________________________<?xml:namespace > > prefix = o ns = "urn:schemas-microsoft-com:office:office" /> > > > > * Regards, > > Richard Lovelock > > > > Westminster City Council - Web Support > > Cap Gemini Ernst & Young > > Southbank > > 95 Wandsworth Road > > London > > SW8 2HG > > > > ( 0870 906 7482 > > > > _______________________________________________________ > > > > > > > > > > ======================================================= > > This message contains information that may be privileged or > > confidential > > and is the property of the Cap Gemini Ernst & Young Group. It is > > intended > > only for the person to whom it is addressed. If you are not the intended > > recipient, you are not authorised to read, print, retain, copy, > > disseminate, > > distribute, or use this message or any part thereof. If you receive this > > message in error, please notify the sender immediately and delete all > > copies > > of this message. > > ======================================================= > > > > > > > > ======================================================= > > This message contains information that may be privileged or confidential > > and is the property of the Cap Gemini Ernst & Young Group. It is > > intended only for the person to whom it is addressed. If you are not the > > intended recipient, you are not authorised to read, print, retain, copy, > > disseminate, distribute, or use this message or any part thereof. If you > > receive this message in error, please notify the sender immediately and > > delete all copies of this message. > > ======================================================= > > > > > > -- > > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > -- > > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > ======================================================= > > This message contains information that may be privileged or confidential > > and is the property of the Cap Gemini Ernst & Young Group. It is intended > > only for the person to whom it is addressed. If you are not the intended > > recipient, you are not authorised to read, print, retain, copy, > > disseminate, distribute, or use this message or any part thereof. If you > > receive this message in error, please notify the sender immediately and > > delete all copies of this message. > > ======================================================= > > > > > > -- > > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > -- > > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > ======================================================= > > This message contains information that may be privileged or confidential > and is the property of the Cap Gemini Ernst & Young Group. It is intended > only for the person to whom it is addressed. If you are not the intended > recipient, you are not authorised to read, print, retain, copy, disseminate, > distribute, or use this message or any part thereof. If you receive this > message in error, please notify the sender immediately and delete all copies > of this message. > > ======================================================= > > > > > > -- > > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > ======================================================= > This message contains information that may be privileged or confidential and > is the property of the Cap Gemini Ernst & Young Group. It is intended only > for the person to whom it is addressed. If you are not the intended > recipient, you are not authorised to read, print, retain, copy, disseminate, > distribute, or use this message or any part thereof. If you receive this > message in error, please notify the sender immediately and delete all copies > of this message. > ======================================================= > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > ======================================================= > This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst & Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorised to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. > ======================================================= > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
