db().select(db.test.date,db.test.url,db.test.hits.sum(),groupby= (db.test.date,db.test.url))
should be db().select(db.test.date,db.test.url,db.test.hits.sum(),groupby= db.test.date|db.test.url) On Aug 5, 10:31 pm, Dutch opera <[email protected]> wrote: > Below is a query that works. It does a sum and groups by date. > > db().select(db.test.date,db.test.url,db.test.hits.sum(),groupby= > (db.test.date)) > > Here is a query that does not work. I just added an additional > groupby. > > db().select(db.test.date,db.test.url,db.test.hits.sum(),groupby= > (db.test.date,db.test.url)) > > I get this error... > > Traceback (most recent call last): > File "<console>", line 1, in <module> > File "/home/dutch/workspace/test/gluon/sql.py", line 2144, in select > query = self._select(*fields, **attributes) > File "/home/dutch/workspace/test/gluon/sql.py", line 2087, in > _select > sql_o += ' GROUP BY %s' % attributes['groupby'] > TypeError: not all arguments converted during string formatting > > So...why does this happen? I would have no problem writing this in > SQL. Tried to view the SQL using _select but got the same error. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
