The "\" sign in Select Statement

[bogdanzagan]

Hello,
I have a simple ADOdb Select statement:
Execute("SELECT nume_complet_useri FROM dbo.table WHERE field = '" . ($Param) . "'") or DIE($sphinx1conn->ErrorMsg());

The $Param is the value of a textfield.

The problem is when I enter a value like "AAA\BBB.CCC"
If I use <?php echo $HTTP_POST_VARS["textfield"]; ?> I see that actually the passed value is AAA<font color="red">\</font>BBB.CCC

So, the MsSql server is not returning the row ! Can I do something that the passed value to be actually what I type in the textfield ?
Thanx

[Anon]

Have a look at : magic_quotes_gpc
When this mode is enabled, it protects your string !
Ex : Let's go become Let\'s go
AA\bb become AA\bb

[bogdanzagan]

I used set_magic_quotes_runtime(0); but I have the same result !

[Anon]

Turn off your : magic_quotes_gpc
In your php.ini

[bogdanzagan]

Sorry, I use ADOdb wich manages all this stuff.
By the way, I have linux and I use as a Database server MsSql... and everything is working fine...except for the NT Autentication...In asp with IIS I have a Request.ServerVariables("Logon_User")...wich some time kill the server becouse of the DLL.HOST.

Have fun