From: [EMAIL PROTECTED]
Operating system: Linux RedHat8.0
PHP version: 4CVS-2002-12-16 (stable)
PHP Bug Type: Sybase-ct (ctlib) related
Bug description: Query to float fields don't return the decimal part
Hi PHP people, first as all thank's for a great software, well I'm testing
the new php-4.3.0 in my Redhat 8.0 box, httpd-2.0.40-13,
phpCVS-2002-12-16(stable), I built rpms of this versión using sybase-ct
with freetds-0.60, I had in the past the same freetds but with
php-4.2.4-dev and everyhing works ok, but now when I query float fields of
a Microsoft sql server dont't return the decimal part of my float numbers
and this is very important to me, I get just the integer part. Here it
goes my configuration...
'./configure' '--host=i686-pc-linux-gnu' '--build=i686-pc-linux-gnu'
'--target=i686-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr'
'--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin'
'--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include'
'--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var'
'--sharedstatedir=/usr/com' '--mandir=/usr/share/man'
'--infodir=/usr/share/info' '--prefix=/usr' '--with-config-file-path=/etc'
'--enable-force-cgi-redirect' '--disable-debug' '--enable-pic'
'--disable-rpath' '--enable-inline-optimization' '--with-bz2' '--with-db3'
'--with-curl' '--with-dom=/usr' '--with-exec-dir=/usr/bin'
'--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-gd'
'--enable-gd-native-ttf' '--with-ttf' '--with-gdbm' '--with-gettext'
'--with-pdflib=shared' '--with-tiff-dir=/usr' '--with-ncurses'
'--with-gmp' '--with-iconv' '--enable-xslt=shared' '--with-jpeg-dir=/usr'
'--with-openssl' '--with-png' '--with-pspell' '--with-regex=system'
'--with-xml' '--with-expat-dir=/usr' '--with-zlib' '--with-layout=GNU'
'--enable-bcmath' '--enable-exif' '--enable-ftp' '--enable-magic-quotes'
'--enable-safe-mode' '--enable-sockets' '--enable-sysvsem'
'--enable-sysvshm' '--enable-discard-path' '--enable-track-vars'
'--enable-trans-sid' '--enable-yp' '--enable-wddx' '--without-oci8'
'--with-pear=/usr/share/pear' '--with-imap=shared' '--with-imap-ssl'
'--with-kerberos=/usr/kerberos' '--with-ldap=shared'
'--with-mcal=shared,/usr' '--with-mcrypt=shared,/usr'
'--with-mhash=shared,/usr' '--with-mysql=shared,/usr'
'--with-pgsql=shared' '--with-snmp=shared,/usr' '--with-snmp=shared'
'--with-sybase-ct=shared,/usr' '--with-xslt-sablot=shared,/usr'
'--with-sablot-js=shared,/usr' '--enable-ucd-snmp-hack'
'--with-unixODBC=shared' '--enable-memory-limit' '--enable-bcmath'
'--enable-shmop' '--enable-versioning' '--enable-calendar' '--enable-dbx'
'--enable-dio' '--enable-mcal' '--with-apxs2=/usr/sbin/apxs'
Here the sript I use.. to query
$idres=mssql_query ("SELECT
NUMDOC,FECHA,DESCCONCI,DESCRIPCION,DEBE,HABER,BRUTO,PAGO FROM submayor
WHERE CODAREA='$Area' and FECHA>=convert(DATETIME,'$fdesde',102) and
FECHA<=convert(DATETIME,'$fhasta',102) order by FECHA",$id);
}
$cant=mssql_num_rows ($idres);
$TOTD=0;
$TOTH=0;
$TOTI=0;
$TOTP=0;
for ($i =1; $i <= $cant; $i++) {
$row = mssql_fetch_array ($idres);
$NUMDOC=$row["NUMDOC"];
$FECHCOB=$row["FECHA"];
$DESCCLI=$row["DESCCONCI"];
$OBSERVAC=$row["DESCRIPCION"];
$DEBE=$row["DEBE"];
$HABER=$row["HABER"];
$BRUTO=$row["BRUTO"];
$PAGO=$row["PAGO"];
}//end for
DEBE HABER BRUTO PAGO are float fields
Bye Aliet
--
Edit bug report at http://bugs.php.net/?id=21047&edit=1
--
Try a CVS snapshot: http://bugs.php.net/fix.php?id=21047&r=trysnapshot
Fixed in CVS: http://bugs.php.net/fix.php?id=21047&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=21047&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=21047&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=21047&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=21047&r=support
Expected behavior: http://bugs.php.net/fix.php?id=21047&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=21047&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=21047&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=21047&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=21047&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=21047&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=21047&r=isapi
