How to accept apostrophe entered by user
My problem is the following:
I am trying to construct an Insert statement at server side using input by the user. I am allowing the user to enter 'Memo' using a multi-line text box. The insert statement works fine for whatever the user enters except when he enters an " ' " as I am constructing insert statement using a string variable. The ADO is interpreting the " ' " to be the end of Insert statement.
How to solve this?