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.