Bug #9257 Updated: Problem with values returned from a select statement

ID: 9257 Updated by: sniper Reported By: fabionl@baydenet.com.br Old-Status: Assigned Status: Closed Bug Type: InterBase related PHP Version: 4.0.4pl1 Assigned To: jah Comments: This should be fixed in CVS now. --Jani Previous Comments: --------------------------------------------------------------------------- [2001-02-16 08:26:30] fabionl@baydenet.com.br ok... really thx... :) []'s --------------------------------------------------------------------------- [2001-02-14 18:54:42] jah@php.net Yes, this seems quite bad, and I got today another email (privately) complaining about a same kind of thing happening. I'm afraid it takes a few days before I can really look what's happening, it can take some time (which I don't have much...). Fortunately, the other bug reporter gave quite a good hint where exactly in the source the bug seems to be. --------------------------------------------------------------------------- [2001-02-14 08:14:05] fabionl@baydenet.com.br $sele = "select data,hora,historico,valor from saldos "; $sele .= "where data between '$dataini1' and '$datafin1'"; $q = ibase_prepare($i,$sele); $result = ibase_execute($q); while ($row = ibase_fetch_object($result)) { echo $row->VALOR; } //------------ saldos is a view and its defined as: CREATE VIEW "SALDOS" ( "DATA", "HORA", "CAIXA", "VALOR", "HISTORICO" ) AS SELECT data,hora,caixa,valor,historico FROM entradas UNION SELECT data, hora, caixa, (valor*-1) "VALOR", historico FROM saidas ; The field "valor" in the tables "entradas" and "saidas" is defined as numeric(11,2)... The problem is that the code above returns for example "10.10" when the value of the field is "10.01"... it's a really big problem, and i dont know what to do... :( --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=9257&edit=2