ID: 9257
Updated by: sniper
Reported By: [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
ok... really thx... :)
[]'s
---------------------------------------------------------------------------
[2001-02-14 18:54:42] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
$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
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
