SQL/Access - Newline char woes

bramkumar

New member
Joined
Jul 9, 2004
Messages
2
Programming Experience
Beginner
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

Forum Admin
Staff member
Joined
Jun 2, 2004
Messages
123
Location
VA
Programming Experience
10+
Take a look at HTMLEncode/HTMLDecode methods.
 

bramkumar

New member
Joined
Jul 9, 2004
Messages
2
Programming Experience
Beginner
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!
 
Top Bottom