ID:               22618
 User updated by:  mattiass at commentor dot se
 Reported By:      mattiass at commentor dot se
-Status:           Open
+Status:           Closed
 Bug Type:         Sybase-ct (ctlib) related
 Operating System: 2.4.19-16mdksecure
 PHP Version:      4.3.1
 New Comment:

Sniper,

I just checked the latest cvs. I only copied the ext/sybase_ct lib over
to php 4.3.1 since I have some serious issues with gd in the newer cvs
builds.

And it works like a charm..

Case closed..! Thanks..


Previous Comments:
------------------------------------------------------------------------

[2003-03-11 01:40:04] mattiass at commentor dot se

Sniper,

I just checked the latest cvs. I only copied the ext/sybase_ct lib over
to php 4.3.1 since I have some serious issues with gd in the newer cvs
builds.

And it works like a charm..

Case closed..! Thanks..

------------------------------------------------------------------------

[2003-03-10 09:35:07] [EMAIL PROTECTED]

Please try using this CVS snapshot:

  http://snaps.php.net/php4-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip




------------------------------------------------------------------------

[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

Reply via email to