When returning multiple rows from a table and some of the fields contain floating point figures (ie Datatypes of Money, Smallmoney or Float).  The first row is returned fine.  Any row after the first, the floating point numbers are sent back as integers.

I have tried sybase_fetch_row, sybase_fetch_array and sybase_fetch_assoc.  All of these produce the same affect.

If I run two lines of SQL to return the two rows seperately, each row will be fine.  It only happens when you select a number of rows at a time.

I have tried this with the above datatypes. Info in our setup is shown below:

Adaptive Server Enterprise/12.0.0.4/P/SWR 10044 ESD 2/Sun_svr4/OS 5.6/1789/32bit/FBO/Mon Feb  4 23:47:53 2002

Apache 1.3.27 with PHP running as a DSO

PHP configureation:

'./configure' '--without-mysql' '--with-apxs=/usr/local/phpapache/bin/apxs' '--enable-track-vars' '--with-jpeg-dir=/export/home/www/packages/jpeg' '--enable-safe-mode' '--with-sybase-ct=/usr/local/sybase/12.0/OCS-12_0' '--with-zlib' '--with-gd' '--with-png-dir=/export/home/www/packages/png' '--with-ttf=/export/home/www/packages/freetype' 

Here is a print_r of the $row which selected two rows where both vat and discount should be the same values in both rows: (I have checked the table in sybase and they are both the same values!)

Array
(
    [transactionid] => 307
    [userid] => 28
    [creationdate] => May 14 2003  4:11PM
    [status] => 0
    [subtotal] => 150
    [discount] => 0
    [vat] => 26.25
    [total] => 176.25
    [deleted] => 0
)
Array
(
    [transactionid] => 308
    [userid] => 28
    [creationdate] => May 14 2003  4:11PM
    [status] => 0
    [subtotal] => 150
    [discount] => 0
    [vat] => 26
    [total] => 176
    [deleted] => 0
)

Cheers.......