How are you connected?. Do you use an ODBC conenction, or just a plain query in isqlw.exe, or? In any case you should check your connection settings. Otherwise you might be able to typical state in your query: SET ANSI_WARNINGS <OFF|ON> etc.... -----Original Message----- From: Omar To: php-windows@lists.php.net 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 and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query. (severity 16) I don?t know what to do, where to look... Thanks for any help. -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
