[web2py] sqlite int field that behave as string ?

[Sebastian E. Ovide]

Hi All,

I have a field defined as integer but for some reason it is string....


In [34]: db.agreement.client_stars.type
Out[34]: 'integer'

In [35]: db(db.agreement.client_stars >10
).select(db.agreement.client_stars).first()
Out[35]: <Row {'client_stars': 5}>

In [36]: db._lastsql
Out[36]: 'SELECT  agreement.client_stars FROM agreement WHERE
(agreement.client_stars > 10);'


note: probably (I don't remember) it was String at some point...

any ideas ?

-- 
Sebastian E. Ovide