I have this code on a form:
<TEXTAREA NAME="fldComment" ROWS="3" COLS="30"></TEXTAREA>
when submitted it inserts into SQL2000 with a field type of ntext (I have also tried text).
The problem is that if the enter key is hit when inputting data in the form the data is truncated where the enter key was pressed when it is inserted into the database.
I have a different form / database table that is exactly the same as far as I can tell that does allow the enter key on the form, it just doesn't preserve it in the database, which is ok.
Any ideas on what could be causing the data to be truncated after the enter key would be appreciated.
<TEXTAREA NAME="fldComment" ROWS="3" COLS="30"></TEXTAREA>
when submitted it inserts into SQL2000 with a field type of ntext (I have also tried text).
The problem is that if the enter key is hit when inputting data in the form the data is truncated where the enter key was pressed when it is inserted into the database.
I have a different form / database table that is exactly the same as far as I can tell that does allow the enter key on the form, it just doesn't preserve it in the database, which is ok.
Any ideas on what could be causing the data to be truncated after the enter key would be appreciated.
#'