pls try (not tested)
*controllers side*
def something():
query = (db.stock.id == db.products.stock)
results = db(query).select(db.products.ALL, db.stock.ALL,count,
groupby=db.products.model)
return dict(query = query, results = results)
*views side*
db(query).select(db.products.ALL)
best regards,
stifan
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
