ID: 25283
Updated by: [EMAIL PROTECTED]
Reported By: larry_li at contractor dot amat dot com
-Status: Feedback
+Status: No Feedback
Bug Type: MSSQL related
Operating System: W2K Server
PHP Version: 4.3.2
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[2003-08-28 03:21:05] [EMAIL PROTECTED]
Remove all old PHP dlls from your system and install the latest PHP
release, 4.3.3 first.
------------------------------------------------------------------------
[2003-08-28 00:31:19] larry_li at contractor dot amat dot com
Description:
------------
I have a table likes:
plant char(4),
partID char(18),
movementType char(3),
txnDate char(8),
quantity int,
price smallmoney
I got php.exe freezing while I was trying to query this table by php. I
checked process info on SQL management window and found query was not
closed. I must kill this process id. Sometimes wait type is sleeping,
sometimes is NETWORKIO. First, I just suspend server has not enough
socket memoy space and sql server can't write result back. Finally I
found it's maybe php's fault.
When I change price's type to float from smallmoney, I fixed this
rpoblem. No any query jam happens. I guess maybe php treats
smallmoney's byte length different as SQL server do. Even though SQL
server return everything back, php.exe still think serveral bytes will
be coming. Just my 2 cents. P.S. SQL server is running on the simplify
chinese w2k server.
Reproduce code:
---------------
$date1=date("Ymd",strtotime($date1));
$date2=date("Ymd",strtotime($date2));
$query = "select * from sapinout where txnDate>='$date1' and
txnDate<='$date2'";
$queryResult = $AMC_DB->query($query);
$header="Date\t";
$header.="Plant\t";
$header.="Part ID\t";
$header.="Movement Type\t";
$header.="Quantity\t";
$header.="Price";
$data="";
while ( $row = mssql_fetch_array($queryResult) )
{
$line="";
$value = '"' . $row[txnDate] . '"' . "\t"; $line .= $value;
$value = '"' . $row[plant] . '"' . "\t"; $line .= $value;
$value = '"' . $row[partID] . '"' . "\t"; $line .= $value;
$value = '"' . $row[movementType] . '"' . "\t"; $line .= $value;
$value = '"' . $row[quantity] . '"' . "\t"; $line .= $value;
$value = '"' . $row[price] . '"' . "\t"; $line .= $value;
$data .= trim($line)."\n";
}
Expected result:
----------------
Will return result immedately!
Actual result:
--------------
No any return from web server.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=25283&edit=1
