I think I replied to another post of yours, same topic.
This won't work because select sends SQL to a database server, and this is
where grouping happens, yet math.floor() is Python, not SQL.
Use the book to read about executesql and use it send SQL to your server;
you will still gets rows back.
The DAL is clever, but it doesn't Python math functions into the equivalent
of your backend server's SQL syntax.
On Wednesday, 5 February 2014 01:47:56 UTC+11, art...@xs4all.nl wrote:
>
> How can we make this to work:
>
> group = math.floor(x/25)
>
> rows = db("table").select(group, y, groupby = group)
>
> The above throws an exeption: funtion has no attribute type.
>
> Ultimately we would like to group on a numeric value that is in a range.
> e.g. group the records for x >0 and <500 and for x >500 and <1000 etc.
>
> Thnx
> Arthur
>
>
>
>
>
>
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
