Re: SQL outer join problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Compare phpinfo() on both servers.

Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com



Liz Kim wrote:
>  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???
>
>   

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux