Forwarding to the list for the common good. Lousy Yahoo seems to have disabled posting to the list from the web. --- Alejandro Pancani <apancani@topgroup.com.ar> wrote:
Thank you!!! It solve my problem
Alejandro Pancani apancani@topgroup.com.ar ----- Original Message ----- From: <chaluba@yahoo.com> To: "Alejandro Pancani" <apancani@topgroup.com.ar> Sent: Monday, April 23, 2001 9:52 PM Subject: Re: SQL PROBLEM
This has been reported in the collector by a few people (including me in Sep'00):
http://classic.zope.org:8080/Collector/883/view http://classic.zope.org:8080/Collector/1560/view http://classic.zope.org:8080/Collector/1611/view
They are marked as "pending". I don't know if it has been fixed in a later version or with DCOracle2. At the time, I ended up returning all calculated columns as strings using to_char() to save fractional parts.
Ayhan
--- In zope@y..., "Alejandro Pancani" <apancani@t...> wrote:
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@t...
_______________________________________________ Zope maillist - Zope@z... http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
__________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/
participants (1)
-
Ayhan Ergul