On Apr 5, 11:40 pm, Ross Peoples <ross.peop...@gmail.com> wrote: > You should really be joining the queries: > > records = db(db.person.id==db.cats.owner).select(db.cats.ALL, db.person.ALL) > > Then in your view, you access this by using: > > {{for record in records:}} > <b>{{=record.person.name}}</b>: {{=record.cats.name}} > {{pass}}
Thanks for the info. Works great for web2py. However not that great if I deployed to gae. Got this traceback: ERROR 2011-04-06 06:43:17,658 restricted.py:55] In FILE: /home/kdie/ projek/web2py/applications/init/controllers/my.py Traceback (most recent call last): File "/home/kdie/projek/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/home/kdie/projek/web2py/applications/init/controllers/ my.py:e2011", line 72, in <module> File "/home/kdie/projek/web2py/gluon/globals.py", line 124, in <lambda> self._caller = lambda f: f() File "/home/kdie/projek/web2py/gluon/tools.py", line 2331, in f return action(*a, **b) File "/home/kdie/projek/web2py/applications/init/controllers/ my.py:e2011", line 14, in e2011 File "/home/kdie/projek/web2py/gluon/dal.py", line 5097, in select return self.db._adapter.select(self.query,fields,attributes) File "/home/kdie/projek/web2py/gluon/dal.py", line 2977, in select (items, tablename, fields) = self.select_raw(query,fields,attributes) File "/home/kdie/projek/web2py/gluon/dal.py", line 2926, in select_raw tablename = self.get_table(query) File "/home/kdie/projek/web2py/gluon/dal.py", line 962, in get_table raise RuntimeError, "Too many tables selected" RuntimeError: Too many tables selected line 14 refers to records = db(db.person.id==db.cats.owner).select(db.cats.ALL, db.person.ALL, orderby=db.cats.id)