[Zope] SQL PROBLEM

Alejandro Pancani apancani@topgroup.com.ar
Mon, 23 Apr 2001 18:44:56 -0300


Hi, everybody:

I have the following problem:

when I execute a select sum sentence under zope  the result value is an
integer althought the column type is float.

For example:

select sum(hours)
    from task
    where id_resource=3D14

returns 4 under zope but if I test it under sql_plus it returns 4.5

Does anybody have any idea?
I=B4m using an Oracle 8i database conected to zope with ZOracle DA Produc=
t

Alejandro Pancani
apancani@topgroup.com.ar