Use 'T' or 'F' rather than 'True' of 'False'. Web2py saves boolean
data as 'char' with length 1.
On Aug 19, 1:49 am, Narendran <gunanar...@gmail.com> wrote:
> Hi,
> I added a new boolean field to a table. And I manually updated the
> value of the field outside web2py. Now, I get zero rows for any
> condition I put on that field. Please see the following shell output
> for an idea:
>
> In [7]: offers = db(db.OFFER.IS_PRICE_COMPARED == False).select()
> ...:
>
> In [8]: len(offers)
> Out[8]: 0 #####<-- This is not expected. It should return all the
> rows
>
> In [9]: offers = db(db.OFFER.IS_PRICE_COMPARED == True).select()
> ...:
>
> In [10]: len(offers)
> Out[10]: 0
>
> In [11]: offers = db().select(db.OFFER.IS_PRICE_COMPARED)
> ....:
>
> In [12]: len(offers)
> Out[12]: 668
>
> In [13]: offers[0]
> Out[13]: <Row {'IS_PRICE_COMPARED': False}> ######<-- Notice the value
> being False here
>
> In [14]: offers[1]
> Out[14]: <Row {'IS_PRICE_COMPARED': False}>
