Is the Microsoft sql parser stupid?

[guigouz]

Or this may be a bug in the mssql php module?

That's what happens... I have a form with a textarea field, when the user submits it, it will update a mssql database.
ok, work fine? NO!
I'm having problems when the text in the textarea has single or double quotes ...
I get a warning from mssql "Syntax error near 'quoted word'"...
I tried using strtr($value, '"','\"'); but it didn't help, actually, I think it's translating " to \ ...

well, anyone know how can I tell ms sql server I have a doublequote or singlequote in the query ?

thanks

[Anon]

Escape the bad characters before you place them into the query string.

[Anon]

You have to double your quotes, e.g.:

INSERT INTO tbl VALUES('John''s hat')

Diego