ID: 21662
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: MSSQL related
Operating System: Windows 2000
PHP Version: 4.3.0
New Comment:
The function used to get the data is:
$row = mssql_fetch_array($query_id);
var_dump($row);
Thanks in advance
Previous Comments:
------------------------------------------------------------------------
[2003-01-15 09:06:17] [EMAIL PROTECTED]
In the PHP 4.3.0 exists a bug with the MSSQL single datatype, in the
follow var_dump, you can see the PUNTAJE field.
array(6) {
[0]=>
string(7) "3422864"
["ID"]=>
string(7) "3422864"
[1]=>
string(20) "3.2051283432282E-306"
["PUNTAJE"]=>
string(20) "3.2051283432282E-306"
[2]=>
string(10) "7725000.00"
["ADJUDICADO"]=>
string(10) "7725000.00"
}
But in PHP 4.2.3 the bug doesn't exists, like you can see:
array(6) {
[0]=>
string(7) "3422864"
["ID"]=>
string(7) "3422864"
[1]=>
string(7) "175.652"
["PUNTAJE"]=>
string(7) "175.652"
[2]=>
string(10) "7725000.00"
["ADJUDICADO"]=>
string(10) "7725000.00"
}
The MSSQL fields data type are:
ID = int
PUNTAJE = single
ADJUDICADO = money
The PHP.ini is the same for both versions, the only change is the PHP
version with its extensions.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=21662&edit=1