Re: [web2py] sqlite int field that behave as string ?

2012-04-30 Thread Johann Spies 
On 29 April 2012 17:51, Sebastian E. Ovide sebastian.ov...@gmail.comwrote:

 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...


Where do you see that it is a string?  In lines 34-36 it was an integer.

Regards
Johann
-- 
Because experiencing your loyal love is better than life itself,
my lips will praise you.  (Psalm 63:3)

[web2py] sqlite int field that behave as string ?

2012-04-29 Thread 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