Skip to Content.
Sympa Menu

freetds - AW: [freetds] freetds, php, cron

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Oliver Baden" <obaden AT yahoo.de>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: AW: [freetds] freetds, php, cron
  • Date: Wed, 13 Aug 2003 23:23:02 +0200

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






Archive powered by MHonArc 2.6.24.

Top of Page