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.

Reply via email to