SQL outer join problem
| From: | Liz Kim | 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???