subject:"\[PHP\-WIN\] MS SQL query problem"

RE: [PHP-WIN] MS SQL query problem

2003-08-29 Thread Svensson, B.A.T. (HKG)

PROTECTED] Sent: 28-8-03 19:28 Subject: [PHP-WIN] MS SQL query problem I have a sql query, something like SELECT x FROM server1.table WHERE x IN (SELECT x FROM server2.table) I get a warning when loading the page. This is the warning: Warning: MS SQL message: Heterogeneous queries require the ANSI_NULLS

[PHP-WIN] MS SQL query problem

2003-08-28 Thread Omar

I have a sql query, something like SELECT x FROM server1.table WHERE x IN (SELECT x FROM server2.table) I get a warning when loading the page. This is the warning: Warning: MS SQL message: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ens