ID: 21047
Updated by: [EMAIL PROTECTED]
Reported By: alietss at yahoo dot com
-Status: No Feedback
+Status: Open
Bug Type: Sybase-ct (ctlib) related
Operating System: Linux RedHat8.0
PHP Version: 4CVS-2002-12-16 (stable)
Previous Comments:
------------------------------------------------------------------------
[2003-03-10 02:44:47] mattiass at commentor dot se
Bug still exsists and has done so since php 4.2.3. Float numbers still
only show decimals. The first query row parses correctly, but the rest
of the rows foobars.
------------------------------------------------------------------------
[2003-01-16 01:00:04] php-bugs at lists dot php dot net
No feedback was provided for this bug for over 2 weeks, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
------------------------------------------------------------------------
[2002-12-31 02:23:51] [EMAIL PROTECTED]
Cool! The best way would be to supply a patch which you can make with:
diff -u original_file.c new_file.c > /tmp/file.c.patch
and send put it online somewhere.
Thanks!
Derick
------------------------------------------------------------------------
[2002-12-30 23:59:19] david at sportodds dot com
I've fixed this error by changing the source but how do I post the fix
to the site for inclusion in a future build?
Please assist?
David Hargreave
IT Manager
SportOdds Systems Pty Limited
www.sportodds.com
------------------------------------------------------------------------
[2002-12-16 11:05:37] alietss at yahoo dot com
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 this bug report at http://bugs.php.net/?id=21047&edit=1
