|
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 |