SQL outer join problem

From: Date: Tue, 16 Sep 2008 23:14:49 +0000
Subject: SQL outer join problem
Groups: php.general 
Request: Send a blank email to php-general+get-280324@lists.php.net to get a copy of this message
have a very simple script which connects to a database, execute a query then displays the result. This script uses odbc_connect and functions. There are two identical Apache web servers and one MS SQL database server. When the script is ran on web server #1, all the results are returned correctly. Ran on server #2, however, some entries are missing. Same script, different result.. I am using left outer join in the SQL query and the missing items are the ones that should be canceled out from this join. I directly ran the query on the database and made sure it is not causing and problems. I checked the odbc setting on php.ini and odbc.ini on both servers. No difference. No permission problems either as I am logging in as the same user... Any ideas???

« previous php.general (#280324) next »