PHP 4.0 Bug #8612: Incorrect retrieval of data

From: gc@ebac.co.uk Operating system: Redhat 7.0 PHP version: 4.0.4 PHP Bug Type: ODBC related Bug description: Incorrect retrieval of data 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 -- Edit Bug report at: http://bugs.php.net/?id=8612&edit=1