Re: [PHP] SQL outer join problem

2008-09-17 Thread Chris
Liz Kim wrote: I've tried using the same php.ini file and phpinfo() shows the same info for both servers. I think I've narrowed the problem down a little bit though. After looking into the Driver Manager's log and I found that SQLExtendedFetch is being called on server 2 (incomplete result) and

Re: [PHP] SQL outer join problem

2008-09-17 Thread Liz Kim
I've tried using the same php.ini file and phpinfo() shows the same info for both servers. I think I've narrowed the problem down a little bit though. After looking into the Driver Manager's log and I found that SQLExtendedFetch is being called on server 2 (incomplete result) and SQLFetch on serve

Re: [PHP] SQL outer join problem

2008-09-16 Thread Micah Gersten
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 a

[PHP] SQL outer join problem

2008-09-16 Thread Liz Kim
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