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

[Stig-Arne Nordin]

"J. Cone" wrote:
> =

> I don't know about other databases, but you can get the result you want=
 in
> Oracle with the nvl function, by selecting
> =

>   nvl(optional_number, 0)
> =

> from the database.  If you couldn't control the replacement value and 0=
 had
> an exisiting meaning, I would think that disastrous.

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

-- =

Stig-Arne Nordin | Projektledare
Fysik och teknisk fysik
CHALMERS | G=F6teborgs Universitet
tel 031 772 32 07 | fax 772 3202
http://www.fysiksidan.nu