I have a text box on my page that calls a record field from an SQL database like so:
The field Notes data type is varchar(8000)
When I add an ' (apostrophe) into the text box and submit I get the following error:
Otherwise the record updates when I submit.
Can anyone help?
Thanks.
Code:
<textarea name="EditText" cols="60" rows="5" id="EditText"><% Response.Write obj_RS1("Notes") %></textarea>
The field Notes data type is varchar(8000)
When I add an ' (apostrophe) into the text box and submit I get the following error:
Incorrect syntax near '
Otherwise the record updates when I submit.
Can anyone help?
Thanks.