ID: 29292
Comment by: w dot peereboom at jkz-rkz dot nl
Reported By: jmelville at selectaustralasia dot com dot au
Status: Bogus
Bug Type: MSSQL related
Operating System: Windows 2000 Server SP4
PHP Version: 4.3.8
New Comment:
If have installed php version 4.3.8 and 5.0 but with both versions some
sort of the same problem is comming up. When i select all records from a
View stored in MS SQL 2000 ("SELECT * FROM View_name) i get all the
records while the view on SQL server is definied as SELECT * FROM Table
WHERE field IS NOT NULL. When i run this last query in my query analyser
the result is less records then when i start the view query with my php
application.
I think this has something to do with this same problem.
Winfred
Previous Comments:
------------------------------------------------------------------------
[2004-09-22 01:56:25] jmelville at selectaustralasia dot com dot au
> in the bottom line make sure php
> use updated ntwdblib.dll file.
Thanks momo. I've read #25777 and I understand that there are problems
with PHP using older libraries to talk to SQL Server.
I have ntwdblib.dll versions 7.00.839 (this is the one that ships with
PHP including 4.3.9RC3) and 8.00.194 (which comes with SQL 2000) and
the problem described in this bug shows up with both those libs. Is
there an even newer version that I should be using?
------------------------------------------------------------------------
[2004-09-21 11:21:48] [EMAIL PROTECTED]
ilia introduced this bug on 1.86.2.25 fixing #25777.
all the meaning was discussed there. in the bottom line make sure php
use updated ntwdblib.dll file.
------------------------------------------------------------------------
[2004-09-17 17:30:20] dcrignon at adequasys dot com
I confirm this problem, under Windows 2003 Server, with Apache 2 or 1.3
and PHP 4.3.8 or 5.0.
The only way is to go back to PHP 4.3.3 ...
Not the good solution for me.
Do you know if someone is working on this bug to fix it?
We can adapt our product and trim() any variable to recover good
values, but is it the good solution?..
Thank you for your help!
David
------------------------------------------------------------------------
[2004-08-30 17:41:45] vikinoha at yahoo dot com
PHP 4.3.8
I am experiencing the same problem with non-empty string returned by a
query that should return an empty string.
I have tried to replace the php_mssql.dll file in version 4.3.8 with
the one from 4.3.3, but the problem remains with no change
whatsoever:(
If there is someone familiar with PHP sources, does the php_mssql.c
1.138 revision changes deal with this bug, or it is something
completely unrelated? And also, if the 'illia_0' change (pointed out by
richard dot quadling at bandvulc dot co dot uk) effectively removes this
bug (does it?), why is it then if'd out?
Thanks,
Viktor
------------------------------------------------------------------------
[2004-08-13 12:22:27] richard dot quadling at bandvulc dot co dot uk
Hi.
If the column contains NULL (using Enterprise Manager to enter CTRL+0),
then the output is correct.
But having to convert all '' to NULLs is not right.
Richard.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/29292
--
Edit this bug report at http://bugs.php.net/?id=29292&edit=1
