ID: 21662 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: Windows 2000 PHP Version: 4.3.0 New Comment:
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 Previous Comments: ------------------------------------------------------------------------ [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
