#23167 [Opn->Fbk]: Apache fails when field of some recordset is passed to "switch" operator.

ID: 23167 Updated by: magnus@php.net Reported By: rart at mail dot ru -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: Windows XP PHP Version: 4.3.1 New Comment: Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip Alot have changed since 4.3.1 and this might be fixed. Previous Comments: ------------------------------------------------------------------------ [2003-04-11 09:36:33] rart at mail dot ru If I passed the recordset's field to the "switch" operator then Apache fails: ----- cut here (begin) ----- Apache.exe has encountered a problem and needs to close. We are sorry for the inconvenience. szAppName : Apache.exe szAppVer : 0.0.0.0 szModName : ntdll.dll szModVer : 5.1.2600.1106 offset : 00001d24 ----- cut here (end) ----- The following script can be used to reproduce the problem: ----- cut here (begin) ----- <? // establish connection to database $conn = new COM("ADODB.Connection"); $conn->ConnectionString = "driver={SQL Server}; " . "server=127.0.0.1; " . "database=mydatabase; " . "uid=sa; " . "Trusted_Connection=Yes"; $conn->ConnectionTimeout = 15; $conn->CommandTimeout = 30; $conn->Open(); // select some data $rset = new COM("ADODB.Recordset"); $rset = $conn->Execute("select myfield from mytable"); if (!$rset->eof) { // on the line below Apache will be failed switch ($rset->fields["myfield"]->value) { // ... } } ?> ----- cut here (end) ----- This problem can be avoided in the following way: ----- cut here (begin) ----- $value = $rset->fields["myfield"]->value; switch ($value) { // ... } ----- cut here (end) ----- As far as I can see this is the PHP's bug. Please let me know if I wrong. Below is some information about my workstation: MS Windows XP Professional SP1 MS SQL Server 2000 SP3 Apache 1.3.27 (installed like a service) PHP 4.3.1 If you need some additional information (e.g. some settings from "php.ini") please feel free to ask me. Best regards, Artem Rodygin. ----------- Rhonda Ltd. Vladivostok Russia ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=23167&edit=1