[Zope-DB] Dealing with null values

Paul Browning paul.browning@bristol.ac.uk
Thu, 25 Apr 2002 09:57:55 +0100

--On 25 April 2002 08:55 +0100 Paul Browning <paul.browning@bristol.ac.uk> 

> I've got an Oracle table with some null values
> in one column. What's the best way of
> catching these? The Zope len function gives me:
> Error Type: TypeError
> Error Value: len() of unsized object

The Oracle NVL function looks handy in this context ..... as described at


 The Library, Tyndall Avenue, Univ. of Bristol, Bristol, BS8 1TJ, UK
   E-mail: paul.browning@bristol.ac.uk  URL: http://www.bris.ac.uk/