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: [EMAIL 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
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

Reply via email to