Just add a print row
before the =row(count) line and see what the structure of the row looks like from the console. It might be row['count'] depending on how your data is structured. On Oct 14, 5:20 pm, Alex <yue.a...@gmail.com> wrote: > Hmm, I gave it a try on the view and it doesn't seem to like it. > > I'm doing this on the view: > > {{for row in ranking:}} > <tr> > <td>{{=row.auth_user.first_name}} {{=row.auth_user.last_name}}</ > td> > <td>{{=row(count)}}</td> > </tr> > {{pass}} > > and it's throwing a "name count is not defined" error. > > Am I still missing something? > > On Oct 14, 9:53 am, Alex <yue.a...@gmail.com> wrote: > > > Ahh thank you very much. I'll give it a try. If this is the case, > > then I believe the syntax example in the book/online is incorrect. > > > Chapter 6 - DAL - Grouping and Counting section > > > The book uses square brackets [] instead of parenthesis (). > > > On Oct 14, 9:13 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > ok. You just want > > > > for row in rows: print row.auth_user.first_name, row(count) > > > > On Oct 14, 6:17 am, Alex <yue.a...@gmail.com> wrote: > > > > > Sure thing. > > > > > I have something like: > > > > > count = db.game_session.createdBy.count() > > > > rankings = db((db.game_session.gameWinner == "1") & > > > > (db.game_session.createdBy == > > > > db.auth_user.id)).select(db.auth_user.first_name, > > > > db.auth_user.last_name, count, groupby=db.game_session.createdBy) > > > > > return dict(rankings = rankings) > > > > > On the view I just want to get to reference/display the count column > > > > in each row. > > > > > Thanks! > > > > > On Oct 14, 12:32 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > > > show us the query. > > > > > > On Oct 13, 10:47 pm, Alex <yue.a...@gmail.com> wrote: > > > > > > > Hello, > > > > > > > I have a query that does a select and COUNT on my model. I wish the > > > > > > present the COUNT value of each row on the view but am having > > > > > > trouble > > > > > > figuring out the syntax for doing this. > > > > > > > I have a for loop, iterating through each row in the resultset and > > > > > > tried to follow the example in the book, by using {{=row[count]}} > > > > > > but > > > > > > to no avail. > > > > > > > I took a look at the objects in the row, and noticed that an > > > > > > "_extra" > > > > > > object is returned in the resultset. Looking at the keys in the > > > > > > "_extra" dictionary, I do see the key based on my COUNT column: > > > > > > > ie. COUNT(db.table_name.column) > > > > > > > I tried to access the count value with {{=rows._extra.colName}}, but > > > > > > still had no luck. Is there something obvious I am missing? > > > > > > > Thanks! > > > > > > > I have tried something like: > > > > > > > {{for row in ranking:}} > > > > > > <tr> > > > > > > <td>{{=row.auth_user.first_name}} {{=row.auth_user.last_name}}</ > > > > > > td> > > > > > > <td>{{=row[count]}}</td> > > > > > > </tr> > > > > > > {{pass}}- Hide quoted text - > > > > > > - Show quoted text -- Hide quoted text - > > > > - Show quoted text -- Hide quoted text - > > > - Show quoted text - > >