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]
