From: ryanphpb at ryanjameson dot com
Operating system: windows 2000
PHP version: 4.3.1
PHP Bug Type: Sybase-ct (ctlib) related
Bug description: Strange Rounding Problem with Money Fields
There's an old report #13807 that sounds similar to what I'm experiencing.
The issue is that a value of 11.16 is coming back in my result array as
11. Other values in the same field in the same result are coming back
fine, ie... the previous value was 111.6. So for some reason this field is
rounding wrong but just for this value. When I look at it through ODBC
with MS Access I see 11.16.
--------------------------------
$q = "select producthandle.sellingprice from customerorder, producthandle
where producthandle.id = customerorder.nr and customerorder.nr =
'030216-22782' and class='CO'";
$con = sybase_connect("#server#","#user#","#password#");
$rs = sybase_query($q,$con);
while ($ar=sybase_fetch_array($rs)){
echo $ar['sellingprice'] . "<br>";
}
------------------------ OUTPUT:
111.6
11
33.4
555.3
12.31
1.23
------------------------
The 11 should be 11.16...
The field type is native sybase money.
--
Edit bug report at http://bugs.php.net/?id=22341&edit=1
--
Try a CVS snapshot: http://bugs.php.net/fix.php?id=22341&r=trysnapshot
Fixed in CVS: http://bugs.php.net/fix.php?id=22341&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=22341&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=22341&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=22341&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=22341&r=support
Expected behavior: http://bugs.php.net/fix.php?id=22341&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=22341&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=22341&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=22341&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=22341&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=22341&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=22341&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=22341&r=gnused
