[web2py] Re: orderby on an integer field appears to order as if field is a string

2013-02-17 Thread Neil Johnson
, 2013 11:59:34 PM UTC, Neil Johnson wrote: > > Hello > > I have a query like so > result = db(db.tag_count.user_id == user_id).select(db.tag_count.name, > db.tag_count.count, orderby=~ db.tag_count.count, limitby=(0, 10)) > > where db.tag_count is defined as > &

[web2py] orderby on an integer field appears to order as if field is a string

2013-02-16 Thread Neil Johnson
Hello I have a query like so result = db(db.tag_count.user_id == user_id).select(db.tag_count.name, db.tag_count.count, orderby=~ db.tag_count.count, limitby=(0, 10)) where db.tag_count is defined as db.define_table('tag_count', Field('name'), Field('user_id',