i think it should be:
number_of_records = db(db.countries.id).select().count()
haven't tried it, but you must have all the rows selected to count.
> Hi,
>
> i have this line of code:
>
> number_of_records = db().count(db.countries.id)
>
> i am receiving an error:
> <class 'sqlite3.OperationalError'> near ";": syntax error
> (self=<gluon.dal.SQLiteAdapter object>, *a=('SELECT count(DISTINCT
> countries.id) FROM ;',), **b={})
>
> What is wrong?
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
