On Apr 5, 11:40 pm, Ross Peoples <[email protected]> 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)
