[Zope] SQL PROBLEM

23 Apr 2001

      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=14

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

Does anybody have any idea?
I´m using an Oracle 8i database conected to zope with ZOracle DA Product

Alejandro Pancani
apancani@topgroup.com.ar