[Zope-DB] RE: None

Michael Mauws michael.mauws at ualberta.ca
Fri Apr 30 17:01:55 EDT 2004

Glad that helped, Remy. But changing every dtml-var sounds like overkill. If
the nature of your data truly requires this, an alternative might be to use
Oracle's NVL function. You probably already know about it but, in any case,
it allows you to specify a value with which to replace nulls. E.g., "SELECT
NVL(name,' ') FROM emp;"


> -----Original Message-----
> From: Remy Pinsonnault [mailto:remy_pinsonnault at roche.ca]
> Sent: Friday, April 30, 2004 1:38 PM
> To: michael.mauws at ualberta.ca; zope-db at zope.org
> Subject: RE: None
> 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

More information about the Zope-DB mailing list