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

Stig-Arne Nordin stigarne@fy.chalmers.se
Tue, 04 Sep 2001 16:15:21 +0200


Hello,

I'm running; Zope 2.3.2 (binary release, python 1.5.2, win32-x86) =


Yesterday i installed ZoracleDA-beta5 after having run the alfa5 for
some time. =

After installing the update I noticed that things were not what they
should or even used to be. =


Problem one. This was there with the alfa-version.

If you encounter a null value in the datbase zope returns the value None
under NT.
At least if it is an integer field. =


I tried to work around this by using NVL(field,0) where field is an
integer. When the database value is null zope responds 0.0 under NT!
Performing the same trick direcly in the Oracle DB and the answer is 0
like it should be. OK, so I try a simple workaround by using
ROUND(NVL(field,0),0) which should give the answer 0. The answer is
still 0.0, in addition all non-null values gets a decimal ending! =


Some time ago i fiddled with an zope-on-linux installation where the
null value provide by zope was 0. =


Solutions, explanations or workarounds anyone?

Problem two. New with beta5!!!

Integer field value changed from 12108 to 12108L. This happens for some
of of my integer fields but not for all.

Is there anyone out there who knows of a solution or has seen this
behavior before.
-- =

Stig-Arne Nordin
Fysik och teknisk fysik
CHALMERS | G=F6teborgs Universitet