[Zope] ZOracleDA-beta5 problem; possible bug running NT

J. Cone jcone@g8labs.com
Tue, 04 Sep 2001 16:55:50 +0100


Horrible bodgy hack:
does
  <dtml-var "Integer(Float(field))">
work?

I don't know why Oracle numbers get promoted into Long's and Float's, but I
agree it's annoying.

At 17:47 04/09/01 +0200, Stig-Arne Nordin wrote:
<snip>
>I know the NVL trick, it works. Almost. It yields 0.0 for an integer, I
>want it to be 0.
>I tried Round(nvl(optional_number, 0), 0) got me 0.0 for null