ID: 17066
Comment by: k dot breuer at bbk dot de
Reported By: jasonh at trurocollege dot ac dot uk
Status: No Feedback
Bug Type: ODBC related
Operating System: WinNT 5.0
PHP Version: 4.2.0
New Comment:
09/23/2003
The described problem is still there in PHP 4.3.3 with MSSQL 2000 on a
Windows 2000 Server.
Previous Comments:
------------------------------------------------------------------------
[2002-08-13 19:55:29] [EMAIL PROTECTED]
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.
------------------------------------------------------------------------
[2002-05-07 05:10:29] [EMAIL PROTECTED]
Please try the latest stable snapshot on snaps.php.net/win32 and report
back if it's fixed there.
Derick
------------------------------------------------------------------------
[2002-05-07 05:04:13] jasonh at trurocollege dot ac dot uk
The following code worked fine in 4.0.6 for a trivial stored procedure
(in MSSQL7) that returns multiple result sets, but in 4.2.0 it hangs
(and then timeouts) at the first call to odbc_next_result().
$conn = odbc_connect($ODBC_CONN, $USER, $PASS);
$rs = odbc_exec($conn,$SP);
do {
while (odbc_fetch_into($rs,$row)) {
foreach($row as $f => $v) {
print $f . " = " . $v . "<BR>";
}
}
print "<BR>";
} while(odbc_next_result($rs));
Without the outer loop for odbc_next_result() the code works fine and
returns the data in the first result set, as expected.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=17066&edit=1