Comments needed on idea

[jen_ren]

I want the administration to be able to view results of a survey. I have MX6.1
My access db contains memo fields. When veiwing the result page, if the
{answers} are to long the page just keeps going and going and .....

I was wondering if anyone knows how to make it <br> to the next line. Is the
any report writer program that will work with 6.1 or is that just with 7.

The wrap/wraptext is, my understanding, for cfmail. I have thought of using
the LEN fuction and after so many characters to <br>.

I have not worked with Coldfusion for a long while and having to jump back up
in the saddle quickly is fun but also aggravating when I don't remember things.
So any input would be nice. Thanks.

[jmoshier]

jen_ren,

Not sure if this is what you want or will help but when I have data in a memo
field that I want to hold and show all the returns that were typed into the
field I used this when outputting the data.

<cfoutput>#Replace(fieldname,"#chr(10)#","<br>","a ll")#</cfoutput>

Hope this helps.
Jennifer

[jen_ren]

I put in with my code, but it does not want to <br>.

<cfoutput query="yourview">
<tr>
<td width="494" height="40"><span
class="wrapping">#Replace(yourView.answers,"#chr(1 0)#","<br>","all")#</span><br>
<hr align="left" width="50%" size="1" noshade>
</td>
</tr>
</cfoutput>

it goes on and on and .....

[[CJ]]

try:

#replace(yourView.answers, chr(13)&amp;chr(10) ,'<br />', 'all')#

[jen_ren]

that does not want to work either.
The chr(13) is the amount of characters to go and then <br> on all entries. I am understanding this correctly or not.

[dempster]

CHR(13) &amp; CHR(10) form the newline characters (CR and LF) on most systems.
It sounds like the memo fields do not have any newline characters in them. That
is why the replace suggestions will not work. If you are displaying the output
in an HTML format, the text should wrap automatically to the width of the page
or the table cell. This would be the case unless you are using PRE tags or if
there are no spaces in the text. Could you give us a link to see what your
output looks like? -Paul

[jen_ren]

Why am I not looking at some of the small things. You were right. I did not have any spaces/newline. I corrected my test data and it worked correctly. :D