SQL/Access - Newline char woes

[bramkumar]

My ASP pages routinely retrieve multiline textual data from the memo field in my Access database. It works fine. The only problem is when I try to get my ASP pages to accept multiline text from a form and put it into the database (in the same memo field). It simply doesnt work, possibly due to the database assuming that the first newline character in my string signals the end of the SQl command!!

Is there a turnaround?

 

[Neal]

Take a look at HTMLEncode/HTMLDecode methods.

 

[bramkumar]

thanks neal!

as it turns out though, the problem was with me using the GET method rather than the Post method to submit data from my form. it works great now!