RE: [PHP-WIN] MS SQL query problem
| From: | HKG) | Date: | Fri, 29 Aug 2003 08:16:45 +0000 |
| Subject: | RE: [PHP-WIN] MS SQL query problem | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-21275@lists.php.net to get a copy of this message | ||
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