[Zope-DB] RE: None

Remy Pinsonnault remy_pinsonnault at roche.ca
Fri Apr 30 15:38:24 EDT 2004

Michael this is a good solution. It works!

That is what I will do but what annoys me is that I will have to change
every single dtml-var of my current system to reflect this (the application
is running with ZODBCDA and does not have the problem with this DA...)



-----Original Message-----
From: Michael Mauws [mailto:michael.mauws at ualberta.ca] 
Sent: April 30, 2004 11:58 AM
To: zope-db at zope.org
Cc: remy_pinsonnault at roche.ca
Subject: None


The solution to your problem may be as simple as putting the null="" option
within your dtml-var tags or, alternatively, null=" ", depending on the
desired outcome. In any case, note that any null values returned by Oracle
are rendered as "None" unless you specify how they are to be dealt with
using the "null=" option. So since I tend not to store zero values in my
tables, I often write things like <dtml-var AMOUNT_DUE null="0.00"> to avoid
having "None" displayed.

Hope this helps,

michael mauws

More information about the Zope-DB mailing list