See
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Grouping-and-counting.
On Friday, December 28, 2018 at 6:46:25 AM UTC-5, Jonsubs wrote:
>
> Hi all,
> I'd like to know how to access the ".count()" result of a query from a
> view.
>
> I have the following query in
pardon, not sure got what you want to achieve
think if you want to count the rows data, should it better to count the
data first (using compute in table constructor or count it manually before
insert to the table) before put it on table?
or do the count calculation manually on the fly (on the
works like a charm!
thank you very much!
On Fri, Dec 28, 2018 at 5:11 AM Leonel Câmara
wrote:
> Don't use fields=, fields is not a keyword argument so it's going into
> attributes, when it reaches select_wcols you endup having a fields keyword
> argument and a fields value in arguments which
Thanks Stifan,
I see how can I do that for the whole query.
How can I do this row-wise? Can I create a "count_db" variable per row? As
I'm grouping by game and counting how many entries I have per game (after
grouping them), I would like to show the count per row.
The closest I got so far is by
So generally a perfect scenario could be if I use requireslogin on the
first step that requires login, and the subsequent steps from there I would
specify as requiresignature only, and this way all the subsequent steps
practically speaking would be under double protection, login AND signature,
as
just assign it to variable then pass it to the view
*e.g. (not tested)*
*controllers/default.py*
def index():
count_db = db(db.person.id > 0).count()
dict(count_db = count_db)
*views/default/index.html*
{{= count_db}}
*ref:*
Hi all,
I'd like to know how to access the ".count()" result of a query from a view.
I have the following query in the controller:
rows =
db(db.probdata).select(db.probdata.game,db.probdata.game.count(),groupby=db.probdata.game)
And would like to show both the 'game' field and the number of
You may want to generate a link that a not logged in user can use. You may
want to use signature to validate that a user comes from a specific step
where he acquires the signature.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py
Don't use fields=, fields is not a keyword argument so it's going into
attributes, when it reaches select_wcols you endup having a fields keyword
argument and a fields value in arguments which gives you that error.
Change this too:
cofounders =
I am taking the table cofounder and making an inner join with auth_user and
an outer join with cofounder_proposal:
cofounders =
db((db.cofounder.company==company_id)&(db.cofounder.created_by==auth.user)).select(
fields=[db.auth_user.first_name.with_alias('first_name'),
10 matches
Mail list logo
