php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #23167 Apache fails when field of some recordset is passed to "switch" operator.
Submitted: 2003-04-11 09:36 UTC Modified: 2003-04-21 09:22 UTC
Votes:1
Avg. Score:1.0 ± 0.0
Reproduced:0 of 0 (0.0%)
From: rart at mail dot ru Assigned:
Status: No Feedback Package: MSSQL related
PHP Version: 4.3.1 OS: Windows XP
Private report: No CVE-ID: None
View Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: rart at mail dot ru
New email:
PHP Version: OS:

 

 [2003-04-11 09:36 UTC] 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-04-11 19:32 UTC] magnus@php.net
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.
 [2003-04-21 09:22 UTC] sniper@php.net
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.


 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat Dec 21 16:01:28 2024 UTC