ID: 17357 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: ODBC related Operating System: Windows 2000 Advanced Server PHP Version: 4.2.1 New Comment:
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. Previous Comments: ------------------------------------------------------------------------ [2002-05-22 09:09:09] [EMAIL PROTECTED] 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
