Omitting Text String Punctuation on Submit 1

[globularbob]

Hello

I have a text area that I'm trying to submit to a database. It works great until punctuation marks appear in the string. For example, when someone places an apostrophe, the sql string thinks that is the end of the statement and gives me an error because it doesn't know what to do with the rest of the line. Does anyone know of a quick workaround?

Thanks in advance!

GB

 

[hithere]

<%
server.htmlencode(&quot;textareaname&quot
%> &quot;Where's the Ka-Boom? There's supposed to be an Earth-shattering Ka-Boom!&quot;
Marvin the Martian

 

[globularbob]

Works for me. THANKS!