Dealing with Apostrophe's and Pipe symbols
Posted on 1998-11-04
I need someone's help with dealing with apostrophe's and pipe symbol's. I am trying to insert text from a HTML FORM to a SQL statement using the UPDATE and INSERT methods. My issue is whenever one of these symbols get put into the SQL statement in my ASP file, it chokes!!
I understand that you need to get a double '' say to keep the quote within a literal but I can't figure how to get this done. I have read to try and use the Replace but it does not work for me. I was also advised to build a function that would search for a ' and replace it with '' before the INSERT or UPDATE.
The fact is that I don't know how to do it! Can anyone provide me with some code and explanation on how to resolve this issue....