Whenever i enter a single quote( ) in a text box and try to insert into a database,an error occurs.
my syntax for inserting into the database is
<%
conn.execute "insert into tab1 (a,b) values ("&request.form("a")&","&request.form("b")&")"
%>
The above syntax works fine for all,except a single quote( ).
Any help!!!