ID: 22618
Updated by: [EMAIL PROTECTED]
Reported By: mattiass at commentor dot se
-Status: Open
+Status: Duplicate
Bug Type: Sybase-ct (ctlib) related
Operating System: 2.4.19-16mdksecure
PHP Version: 4.3.1
New Comment:
Dup of #21047
Previous Comments:
------------------------------------------------------------------------
[2003-03-10 03:27:47] mattiass at commentor dot se
Good morning,
As described in bug #21047 there is still a problem with the sybase ct
library and float numbers (as described bellow)..
Configuration:
===========================
'./configure'
'--with-apxs=/usr/local/apache/apache_1.3.27+php_4.3.1/bin/apxs'
'--with-pear=/usr/local/Zend/pear' '--enable-magic-quotes'
'--with-mysql' '--enable-trans-sid' '--enable-sockets'
'--with-sybase-ct=/opt/sybase-11.9.2/' '--with-pdflib'
'--enable-static-pdflib' '--enable-ftp'
'--prefix=/usr/local/php/php_4.3.1'
'--with-config-file-path=/usr/local/php/php_4.3.1/etc'
'--with-pear=/usr/local/php/php_4.3.1/etc/pear'
'--with-gd=/usr/local/lib' '--with-jpeg-dir' '--with-zlib'
'--enable-bcmath' '--with-snmp' '--with-openssl' '--enable-sockets'
'--with-curl' '--with-curlwrappers'
Software versions:
============================
Sybase 11.9.2
FreeTDS 0.60
Apache 1.3.27
Script:
============================
<?
$db = @sybase_connect("SYB_VALEN", "projuppf_test", "glasklar") or die
(sybase_get_last_message());
$sql =
"
select
convert(varchar(12), tr.datum, 112),
tt.typnamn,
tr.kommentar,
tr.fakturerbartiddef,
tr.anttimmar,
tr.initialer
from
tidrapport tr,
tidtyp tt
where
tr.projektnr = 7 and
tr.typid = tt.typid and
tr.datum between '20030101' and '20030131'
order by
tr.datum
";
$rs = sybase_query($sql);
while (list($datum,$typnamn,$kommentar,$fakt,$timmar,$initialer) =
sybase_fetch_array($rs))
{
echo $datum .", ". is_float($fakt) . ", ". is_float($timmar).
"<br>\n";
}
?>
Output on php 4.3.1
=======================
20030102, 1, 1
20030103, ,
20030103, ,
20030107, ,
20030107, ,
Output in php 4.2.2
=======================
20030102, 1, 1
20030103, 1, 1
20030103, 1, 1
20030107, 1, 1
20030107, 1, 1
------------------------------------------------------------------------
[2003-03-10 02:54:47] mattiass at commentor dot se
Good morning,
As described in bug #21047 there is still a problem with the sybase ct
library and float numbers (as described bellow)..
Configuration:
===========================
'./configure'
'--with-apxs=/usr/local/apache/apache_1.3.27+php_4.3.1/bin/apxs'
'--with-pear=/usr/local/Zend/pear' '--enable-magic-quotes'
'--with-mysql' '--enable-trans-sid' '--enable-sockets'
'--with-sybase-ct=/opt/sybase-11.9.2/' '--with-pdflib'
'--enable-static-pdflib' '--enable-ftp'
'--prefix=/usr/local/php/php_4.3.1'
'--with-config-file-path=/usr/local/php/php_4.3.1/etc'
'--with-pear=/usr/local/php/php_4.3.1/etc/pear'
'--with-gd=/usr/local/lib' '--with-jpeg-dir' '--with-zlib'
'--enable-bcmath' '--with-snmp' '--with-openssl' '--enable-sockets'
'--with-curl' '--with-curlwrappers'
Software versions:
============================
Sybase 11.9.2
FreeTDS 0.60
Apache 1.3.27
Script:
============================
<?
$db = @sybase_connect("SYB_VALEN", "projuppf_test", "glasklar") or die
(sybase_get_last_message());
$sql =
"
select
convert(varchar(12), tr.datum, 112),
tt.typnamn,
tr.kommentar,
tr.fakturerbartiddef,
tr.anttimmar,
tr.initialer
from
tidrapport tr,
tidtyp tt
where
tr.projektnr = 7 and
tr.typid = tt.typid and
tr.datum between '20030101' and '20030131'
order by
tr.datum
";
$rs = sybase_query($sql);
while (list($datum,$typnamn,$kommentar,$fakt,$timmar,$initialer) =
sybase_fetch_array($rs))
{
echo $datum .", ". is_float($fakt) . ", ". is_float($timmar).
"<br>\n";
}
?>
Output on php 4.3.1
=======================
20030102, 1, 1
20030103, ,
20030103, ,
20030107, ,
20030107, ,
Output in php 4.2.2
=======================
20030102, 1, 1
20030103, 1, 2
20030103, 1, 3
20030107, 1, 4
20030107, 1, 5
Aparently, after the first query, float numbers wont work
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=22618&edit=1
