.....
return dict(rows=rows, count=count, groupby=groupby)
On Thursday, March 27, 2014 9:21:01 AM UTC+1, Dave S wrote:
>
>
> I know I'm a bit slow, but ...
>
> On Wednesday, March 26, 2014 4:21:27 PM UTC-7, Dave S wrote:
>>
>> On Wednesday, March 26, 2014 12:58:36 PM UTC-7, Niphlod wrote:
>>>
>>> assuming.....
>>>
>>> count = db.table.id.count()
>>> groupby = db.table.birthday.month()
>>>
>>> #you can do
>>>
>>> rows = db(db.table.id >0).select(count, groupby, groupby=groupby)
>>> for row in rows:
>>> print row[count], row[groupby]
>>>
>>>
>>>
>>> i.e. the variables (count, groupby) you set are automatically
>>> "translated" to the "ugly format" you're referring to.
>>>
>>
>> Okay, that looks good.
>>
>
>
> Except for one tiny detail. I don't want to print the results from the
> controller, I want the view to display them. And when I do the for loop in
> the view,
> I get a ticket for "NameError: name 'count' is not defined". How do I get
> the desired results from my controller to the view and out on the browser
> screen?
>
>
>>
>>> This is the only recommended way to deal with those, because the
>>> row['_extra']["web2py_extract('month',person.birthdate)"]
>>>
>>> is only valid for a specific adapter (in this case, sqlite). This means
>>> that if you switch to mysql, it won't work.
>>>
>>>
>>
>
>
>
>
>
>
>
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
