db insertion - removing apostrophes

[aamaker]

im have a form with a text field that the user, upon submission, is adding to the database (a simple access db)... problem is I need to prevent apostrophes from being written to the db...

I tried adding the following line before the insert statement

MM_formVal = Replace(MM_formVal,"'","''")

but that just prevents the submission from being written to the database alltogether (as opposed to only removing the apostrophe. withthout this line of code its added to the db( with the apostrophe) just fine though.

 

[traingamer]

That code will replace one apostrophe with two. Try:

MM_formVal = Replace(MM_formVal,"'",[b][COLOR=blue]""[/color][/b])

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[aamaker]

my fault, that was one feeble attempt I made at trying to see where the issue was - I still get the same result though, and I've tried the empty quotes that you suggested.

Any other ideas?

Thanks for replying though.

 

[Cheech]

I cant see why that doesn't work, paste this code into a page and see what happens

<%
MM_formVal = "O'Hanlon"
response.Write(MM_formVal)
MM_formVal = Replace(MM_formVal,"'","")
response.Write("<br>")
response.Write(MM_formVal)
%>

[Peace][Pipe]