I have a page that consists of a textarea field, for comments. I am running into trouble inserting the text in the box to the DB. It's SQL Server with a varchar datatype.
Everything submits fine if you enter text with no carrage returns, however, if you are typing along in the text box and hit 'enter', all text up to the carrage return get's inserted into the DB. It looks like any remaining text gets discarded.
Is there a way to use the replace function to replace the carrage returns with a space so I can submit the full string? I have tried chr(13)&chr(10) and vbCrLf, still no luck.
Everything submits fine if you enter text with no carrage returns, however, if you are typing along in the text box and hit 'enter', all text up to the carrage return get's inserted into the DB. It looks like any remaining text gets discarded.
Is there a way to use the replace function to replace the carrage returns with a space so I can submit the full string? I have tried chr(13)&chr(10) and vbCrLf, still no luck.
