#21662 [Fbk->Opn]: single data type not well returned
| From: | egarcia at egm dot as | Date: | Thu, 16 Jan 2003 14:09:31 +0000 |
| Subject: | #21662 [Fbk->Opn]: single data type not well returned | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-30256@lists.php.net to get a copy of this message | ||
ID: 21662
User updated by: egarcia@egm.as
Reported By: egarcia@egm.as
-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] sniper@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
------------------------------------------------------------------------
[2003-01-15 09:21:48] egarcia@egm.as
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] egarcia@egm.as
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