php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #58497 Money fields are returned without decimal separator
Submitted: 2009-01-09 07:36 UTC Modified: 2009-01-23 11:46 UTC
From: madeinlisboa at yahoo dot com Assigned:
Status: Closed Package: ingres (PECL)
PHP Version: 5.2.5 OS: WIndows XP SP3
Private report: No CVE-ID: None
 [2009-01-09 07:36 UTC] madeinlisboa at yahoo dot com
Description:
------------
A money field is properly displayed ONLY if it is the first field on a query. Further money fields are shown without decimal separator.

Apache 2.2.8
PHP 5.2.6
php_ingres.dll 2.0.1
Ingres Database 9.3 v139

I even added to environment vars:
II_DECIMAL=.
II_MONEY_FORMAT=L:$
II_MONEY_PREC=2

and in Apache
PassEnv II_DECIMAL
PassEnv II_MONEY_PREC
PassEnv II_MONEY_FORMAT


Reproduce code:
---------------
#1
select
money_field1 as field1,
money_field1 as field2,
from table

#2
select
name as name1,
money_field1 as field1,
money_field2 as field2,
from table

Expected result:
----------------
#1
235.35 235.35
12.20 12.20
10.05 10.05

#2
james 235.35 235.35
andrew 12.20 12.20
john 10.05 10.05


Actual result:
--------------
#1
235.35 23535
12.20 1220
10.05 1005

#2
james 23535 23535
andrew 1220 1220
john 1005 1005


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2009-01-21 08:02 UTC] grant dot croker at ingres dot com
I have an un-submitted fix awaiting verification.
 [2009-01-23 11:46 UTC] grant dot croker at ingres dot com
Thank you for your bug report. This issue has been fixed
in the latest released version of the package, which you can download at
http://pecl.php.net/get/ingres


 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Apr 25 21:01:36 2024 UTC