Populating a MYSQL DB from a textarea
Posted on 2006-11-26
I have the following input in a form on a web site.
<TD> Other Information<br>
<textarea cols = "50" rows = "4" Name = "txtInformation"> </textarea>
The form posts to an asp page which amongst other things populates a MYSQL data base
set rs = conn.Execute("INSERT INTO buy VALUES ('', '"+Information+"')") - lots of other things here but I have taken them out for simplicitiy's sake.
This all works well with normal text
"You are looking good" for instance works fine but as soon as we try
"You're looking good" the system falls down.
The Field in the DB is set to longtext.
Do I need to adjust the field?
Your assistance would be much appreciated