FreeTDS Development Group

["Oliver Baden" <obaden AT yahoo.de>]

Hi Eddie,

>What language are you using for your script insertion?
>Perl or PHP?

I'm using PHP

>For PHP you need to use the addslashes() function to escape characters 
>for Perl you need to hmmmm...lemme try and remember.
>Or this for perl... the quote() function being the fixer of the
problem.

I am using my own function to simulate an addslashes function for mssql

Thanks for the advice but this is definitely not the problem. It seems
to be a timing-problem by freetds that the statement is not interpreted
properly before being sent to mssql-server. I am using my own function
which uses str_replace to replace all characters like single ' to '' and
\ to \\ etc. 

As said before I believe it to be a timing or locale problem since the
first statement in the loop does not create an error. 

PHP generates a statement for mssql and mssql gives me an error that it
cannot compute the statement because somehow characters like -, >,<,=,!
are interpreted as apostrophes.

Thanks again for your thoughts and ideas!

Oliver