Thanks, 0=0 works well enough for me. (This hint is what I wanted)
Thanks again,
Lloyd
On Wed, 2006-12-06 at 10:00 +0100, Mario Frasca wrote:
> Lloyd wrote:
>
> >select a from mytable where (b=0) and
> >
> >and this is a syntax error.
> >
> >
> you're not saying which language you're using.
>
> in Python a common solution looks like this:
> clauses = []
> # add strings to the clauses list, like
> clauses.append('(b=0)')
> # join the parts using appropriate glue
> where = ' AND '.join(clauses)
>
> sometimes I do need something like what you call "an empty clause"...
> some engines accept 'TRUE', others don't know that literal.
> I find this quite convenient:
> '0=0'
>
> hth...
>
> -----------------------------------------------------------------------------
> To unsubscribe, send email to [EMAIL PROTECTED]
> -----------------------------------------------------------------------------
______________________________________
Scanned and protected by Email scanner
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
