[Zope] Re: SQL PROBLEM

Ayhan Ergul chaluba@yahoo.com
Tue, 24 Apr 2001 10:28:05 -0700 (PDT)


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
> > >  http://lists.zope.org/mailman/listinfo/zope-dev
> )
> 


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/