apostrophe bug fixer doesn't work with "s

[reubenb]

hi,

when i use the apostrophe bug fixer in SQL
Replace(MyVariable,"'","''")

when i put a " in the field it stuffs up and gives me a

Type mismatch: '[string: "none"]'

error.

Why? And how do I fix it?

Thanks.

[tboss132]

Hi, i don't understand you fully. Are you using it with ASP? and where does the error come from? Maybe you can paste the full code here and we'll get a better idea. Meanwhile see this sticky (http://www.codingforums.com/showthread.php?t=9843) for some information.

[reubenb]

Nevermind - figured it out

Thanks anyway.