[Zope-DB] ZSQL and update, what is the correct way to deal with nulls?
Tue, 6 May 2003 16:31:03 -0400
On Tue, May 06, 2003 at 02:16:25PM -0600, David Wilbur wrote:
> 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.