PHP 4.0 Bug #8612 Updated: Incorrect retrieval of data

ID: 8612 Updated by: kalowsky Reported By: gc@ebac.co.uk Status: Open Bug Type: ODBC related Assigned To: Comments: The first part of this bug (SQLINTEGER section) should now be set in the PHP4.0.4pl1, please try the latest builds and see if this action continues for you. Previous Comments: --------------------------------------------------------------------------- [2001-01-09 04:26:45] gc@ebac.co.uk Complied version 4.0.4 with openlink support. I had a problem in the compile with SQLINTEGER not defined error message. Followed the following from phpbuilder as a workaround ................ I've post a message in PHP.net's bug database and they have analysised and assigned to some guy named Zeev. I think it should be resolved already or in near future. There is a temp workaround: search for "SQLINTEGER len;" string in /ext/odbc/php_odbc.c file in php4 source directory and replace it with "SDWORD len;" happy with your compiling! silen ...................... This compiles ok, but when trying to retrieve data, the wrong records are returned. e.g. If a table contains the following values. Primary Key is Firstname,Surname. Firstname Surname Fred Smith Fred Jones Bill Bloggs Bill Brown Querying the table for all values will return Fred Smith Fred Smith Bill Bloggs Bill Bloggs Testing the odbc connection with odbctest program from openlink yields the correct answers. I then compiled PHP 3.0.18, and the problem is fixed here. Therefore the bug does not exist in 3.0.18, but does in 4.0.4. Nb My database is Oracle 8.0.5 --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=8612