Re: [web2py] sqlite strange behaviour with boolean

2013-10-17 Thread Tim Richardson
Not annoyed, it all works. I just didn't know how it worked. Have amended the book in the gotchas section. On Friday, October 18, 2013, Niphlod wrote: > don't do that, please. If you're annoyed with web2py's defaults, you can > easily sublass the adapter and make your own adjustments. > > On Thur

[web2py] sqlite strange behaviour with boolean

2013-10-16 Thread Tim Richardson
This is web2py 2.7.4, on Windows, python 2.7.5 I have rows in an sqlite table with a boolean field. Currently all rows have this field set to 0 (via an update query in an sqlite console) When the table is defined in the web2py model as boolean, this query returns no rows: query_rows = db(db