Can someone help asap, i have an asp script that when entering an apostrophe in a comments box, I ge

<i><b>Originally posted by : Jason (jroscoe@riteaid.com)</b></i><br />When entering an apostrphe in a comments box on a form, it get the following error: Microsoft OLE DB provider for ODBC drivers error '80004005'<br />ORA-01756: quoted string not properly terminated. can someone help asap, it's kind of urgent! Thanks<br />

<i><b>Originally posted by : antony (antovelan@usa.net)</b></i><br />thats very simple, before inserting into sQL statement replace u'r single quote by double quote by using following function<br /><br />function doublequote(sqlp)<br />doublequote=replace(sqlp,"'","''")<br />end function<br /><br />now change u'r program sligtly<br /><br />-------------------------<br />changed program by antony<br />-------------------------<br />change var1,var2,var3 into<br /><br /><br />var1=doublequote(request.....)<br />var2=doublequote(request.....)<br />like etc...<br /><br />