[Zope-DB] RE: None

[Remy Pinsonnault]

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...)

Thanks!

Remy

-----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


Remy:

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