[egenix-users] SELECTing with placeholders and NULL values

[Charlie Clark]

On 2004-06-23 at 17:10:26 [+0200], Charles Bearden 
<Charles.F.Bearden at uth.tmc.edu> wrote:
> That's what I'll do.  Some WHERE clauses may have 4 or 5 tests, of which
> three may have NULL or non-NULL values.  I just thought that if I didn't
> have to generate the statements dynamically, the code would be neater.

This is probably superfluous but avoid NULLs altogether if you can: they 
break most relational models and always cause trouble sooner or later. It's 
probably a moot point but TRUE / FALSE would probably make more sense to 
most people.

Checkout http://www.dbdebunk.com for some good points on RDBMS practice.

Charlie
-- 
Charlie Clark
eGenix.com

Professional Python Services directly from the Source
 >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::