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