[Zope] SQL PROBLEM

Dieter Maurer dieter@handshake.de
Tue, 24 Apr 2001 22:12:30 +0200 (CEST)


Alejandro Pancani writes:
 > ...
 > 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
We use ZOracleDA with Oracle 8i and get floats (even when we do not
want them).

However, the DCOracle module packaged with ZOracleDA was
quite old (when we downloaded ZOracleDA).
Fetching an up-to-date DCOracle and putting it into
ZOracleDA had drastically improved the interaction
between Zope and Oracle.

Maybe, ZOracleDA is still bundled with an outdated DCOracle?


Dieter