[Zope-DB] ZSQL and update, what is the correct way to deal with nulls?

Jim Penny jpenny@universal-fasteners.com
Tue, 6 May 2003 16:31:03 -0400

On Tue, May 06, 2003 at 02:16:25PM -0600, David Wilbur wrote:
> hi,  
> i was hoping that someone could describe to me what is the right way to 
> deal with null and zsql methods.  i have come up with the following 
> _EXAMPLE_ below that works... but, this table only has one field that 
> allows null and i'm sitting here saying to my self... wow, what if it 
> had like 10 permutations of nulls?  i just cant envision that i would 
> have to write 10 zsql methods.  i figure that i must be missing 
> something in the rather sparse documentation on zsql...

This is database adapter dependent.  It is something of a corner case.
I know that PoPy and psycopg handle it differently.  So, you really have
to see what the adapter you are using does and adjust accordingly.

Jim Penny