View Complete Thread | FoxWeb Forum Home
Search:
Date:    Msg ID:   
From:    Thread:   
Subject:   
Are you viewing the contents of the memo field in an HTML page?  Remember that carriage returns are displayed as spaces, unless you enclose the text in <PRE> tags, or replace carriage returns with <BR> tags.

FoxWeb Support Team
support@foxweb.com email

Sent by Joe Goldsmith on 09/17/2003 08:02:35 PM:
I have been scratching my head on this for weeks. It seems that when I type text into a textarea box, then store it in a fox memo field, all the text is in one long string. If I were to type in the following:
 
1fsdfdsfsdfdsf
2sdfsfsdfdsfdsfs
3dsfsdfsdsdfsdf
 
4sdfsdsdfsd fsdds dfsdf
5dsdsf
 
It is saved in the memo field as:
 
1fsdfdsfsdfdsf 2sdfsfsdfdsfdsfs 3dsfsdfsdsdfsdf 4sdfsdsdfsd fsdds dfsdf 5dsdsf
 
Here is the code:
 
<%
LOCAL CID, CFIRST, CLAST, CEMAIL, CTELE, CNEWSLET, CNOTES
IF !USED('contact')
 USE data/djm!contact NODATA SHARED IN 0
ENDIF
SELECT contact
SET EXACT ON
M.CNOTES = ""
%>
 
<%
IF Request.FormCount("btnchoice") > 0
M.CNOTES = Request.Form('CNOTES')
 
 SELECT contact
 APPEND BLANK
 REPLACE CNOTES WITH M.CNOTES
%>
 
<TABLE>
 <TR>  
  <TD COLSPAN="2">
   <FORM NAME=contact METHOD=post ACTION="contactus.fwx">
   <TABLE width=100%>
    <TR>
     <TD CLASS=pbsfields1 ALIGN="Left">
          <FONT COLOR="#0000FF"><B>Message</B></FONT>
     </TD>
     <TD CLASS=pbsfields VALIGN="MIDDLE">
      <TEXTAREA name="CNOTES" rows=8 cols=80 WRAP="VIRTUAL" ALIGN="TOP"> <%=(M.CNOTES)%></TEXTAREA>
     </TD>
    </TR>
    <TR>
     <TD CLASS=PBSfields>
       <FONT COLOR="#0000FF"><B>Choose</B></FONT>
     </TD>
     <TD CLASS=pbsfields1 VALIGN="TOP" ALIGN="left">
      <INPUT TYPE=SUBMIT NAME=btnchoice VALUE="Send">
     </TD>
    </TR>
   </TABLE>
   </FORM>
  </TD>
 </TR>
</TABLE>
Anyone have an idea why all thetext is concatenated into one long paragraph?
 
Thanks much,
 
Joe