[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-windows
Subject:    RE: [PHP-WIN] MS SQL query problem
From:       "Svensson, B.A.T. (HKG)" <B.A.T.Svensson () lumc ! nl>
Date:       2003-08-29 8:16:45
[Download RAW message or body]

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

[prev in list] [next in list] [prev in thread] [next in thread]