Re: [web2py] select * from table_name where id IN (1,2,3,4,5,6) Using DAL ?

[Anthony]

>
> list_of_ids = db1(...).select(db1.tablename.id).as_list()
>

That will yield a list of dictionaries. Instead, you can do:

list_of_ids = [r.id for r in db1(...).select(db1.tablename.id)]

Anthony