ID: 21662
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Feedback
+Status: Open
Bug Type: MSSQL related
Operating System: Windows 2000
-PHP Version: 4.3.0
+PHP Version: 4.3.1.1
New Comment:
Acord to your sugestion I use the last php4 stable win version (January
16, 2003, 8:35:37 AM)
I get the original error and many errors more, please tell me how can I
help.
array(12) {
[0]=>
string(7) "3422864"
["ID"]=>
string(7) "3422864"
[1]=>
float(2.2791297027772E-304)
["PUNTAJE"]=>
float(2.2791297027772E-304)
[2]=>
string(10) "7725000.00"
["ADJUDICADO"]=>
string(10) "7725000.00"
}
PHP has encountered an Access Violation at 00BB1493.
Previous Comments:
------------------------------------------------------------------------
[2003-01-15 09:33:47] [EMAIL PROTECTED]
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
------------------------------------------------------------------------
[2003-01-15 09:21:48] [EMAIL PROTECTED]
The function used to get the data is:
$row = mssql_fetch_array($query_id);
var_dump($row);
Thanks in advance
------------------------------------------------------------------------
[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
