Bug #17357 Updated: odbc_fetch_row is broke in 4.2.1

ID: 17357 Updated by: kalowsky@php.net Reported By: atampone@attechcomputer.com -Status: Open +Status: Feedback Bug Type: ODBC related Operating System: Windows 2000 Advanced Server PHP Version: 4.2.1 New Comment: nothing has changed to the odbc_fetch_row function in the last... 3 or 4 releases. Can you please post a sample script, and a copy of a test schema (and data) to reproduce this problem. Previous Comments: ------------------------------------------------------------------------ [2002-05-22 19:48:08] davidr@pophost.com I have experienced the same problem.. My PHP system is Windows XP running IIS and PHP 4.2.0. against a Windows 2K Server with MS-SQL 7.0. I worked around it by closing the connetion and the requerying... The odbc_num_rows also fails... and I had to do a loop of odbc_fetch_row to count the rows in the recordset, then close the connection, then requery. The OpenSource program "WebCalendar" also isn't working with ODBC in 4.2.0 in a Windows environment with SQL Server (can't speak for anything else)... it uses the odbc_fetch_array command...and that too seems to be failing without any error messages. ------------------------------------------------------------------------ [2002-05-22 09:09:09] atampone@attechcomputer.com In previous versions of PHP you could reset the pointer on ODBC resutls using odbc_fetch_row($results,0). This no longer works! I can find no other way to reset ODBC results. If you check for results and then try to loop through the results, you will loose the 1st row! - Anthony ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=17357&edit=1