[Zope-DB] RE: None

[Remy Pinsonnault]

This is another good idea but its still overkill... :)

I have some queries that return up to 60 fields so its painful to do nvl for
each select that could return a NULL...

Thanks again for the ideas!


-----Original Message-----
From: Michael Mauws [mailto:michael.mauws at ualberta.ca] 
Sent: April 30, 2004 5:02 PM
To: remy_pinsonnault at roche.ca; michael.mauws at ualberta.ca; zope-db at zope.org
Subject: RE: None


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

...michael

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