ID: 8612 Updated by: kalowsky Reported By: [EMAIL PROTECTED] Old-Status: Open Status: Closed Bug Type: ODBC related Assigned To: Comments: No user feedback, considered fixed in current. If untrue, please reopen the bug... Previous Comments: --------------------------------------------------------------------------- [2001-03-16 08:33:25] [EMAIL PROTECTED] No user feedback, considered fixed in current. If untrue, please reopen the bug... --------------------------------------------------------------------------- [2001-01-17 09:36:14] [EMAIL PROTECTED] 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. --------------------------------------------------------------------------- [2001-01-09 04:26:45] [EMAIL PROTECTED] 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 --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=8612&edit=2 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]