What is the error. I think it should be groupby=db.auth_user.first_name|db.meal_orders.meal_user
not groupby=(db.auth_user.first_name,db.meal_orders.meal_user) Please give it a try. On Mar 3, 8:44 am, maplye <map...@gmail.com> wrote: > the error happen when the groupby have two field > > db(db.meal_orders.createdate.year()==2009)\ > (db.auth_user.id==db.meal_orders.meal_user)\ > > .select(db.auth_user.first_name,db.meal_orders.money.sum(),groupby=(db.auth_user.first_name,db.meal_orders.meal_user)) > > why? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
