Re: [web2py] db.count()

I tried Antonies code and it works. Thanks. -- --- 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 ht

Re: [web2py] db.count()

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: > near ";": syntax error > (

[web2py] db.count()

Hi, i have this line of code: number_of_records = db().count(db.countries.id) i am receiving an error: near ";": syntax error (self=, *a=('SELECT count(DISTINCT countries.id) FROM ;',), **b={}) What is wrong? -- --- You received this message because you are subscribed to the Google Groups