[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> 
wrote:

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

<blush>
The Oracle NVL function looks handy in this context ..... as described at
http://www.cse.bris.ac.uk/~ccmjs/zope_sql.htm#empty
</blush>

Paul

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