-ASP- Inserting ' character

programming
1

Having a problem when the user try’s to insert the ’ character. I can’t seem to replace that character, is that what I should be doing?

Everything works fine until the ’ comes about, any idea’s?


<% @ Language=VBScript %>
<% 
   a=Request.Form("author")
   e=Request.Form("author_email")
   q=Request.Form("question")
   ans=Request.Form("answer")
%>
<!--#include file="connection.asp"-->
<% SQL = "INSERT INTO FAQ (name, email, question, answer) VALUES ('"&a&"','"&e&"','"&q&"', '"&ans&"')" 
conn.Execute(SQL) %>