Re: try to use bool/booleans with adapter/converter, but...

henk-jan ebbers <[email protected]> Fri, 23 Mar 2007 12:18:15 +0100

Newsgroups	gmane.comp.python.db.pysqlite.user
Message-ID	<[email protected]>

OK, problem solved:

can not use values True or False in SQL-string itself:
    'SELECT idpartner FROM partner WHERE active=True'  (does not work)
I need to used parameters:
    'SELECT idpartner FROM partner WHERE active=:name',{'name':True}  
(works)
(or something like that)
the thae adapters/converters do their work right.

Henk-Jan