Thanks Matt, it is a bug. I think I fixed it in trunk just now, but please give it a try.
Massimo On Apr 6, 11:10 pm, Matt <[email protected]> wrote: > I'm trying to use GAE with web2py and I'm having a few small teething > problems. > > If I do the following: > > db.define_table('company', > db.Field('name', 'string')) > > db.define_table('shop', > db.Field('company', db.company), > db.Field('address', 'string')) > > company = db.company.insert(name = 'Super Books') # assume it gets an > Id of 1. > > db.shop.insert(company = company, address = '10 Main Street') > db.shop.insert(company = company, address = '20 Back Street') > > company = db.company[1]; > > print company > > gives: > > id : 1 > name : Super Books > shop : <gluon.sql.Set object at 0x1e06410> > > So according to the docs > > http://web2py.com/book/default/section/6/6 > > I should be able to do the following: > > for company in db().select(db.company.ALL): > print company.name > > for shop in company.shop.select(): > print ' ---> ', shop.address > > Which when I execute gives the following error: > > Traceback (most recent call last): > File "/Apps/web2py/gluon/restricted.py", line 173, in restricted > exec ccode in environment > File "/Apps/web2py/applications/init/controllers/ > default.py:testing", line 290, in <module> > File "/Apps/web2py/gluon/globals.py", line 96, in <lambda> > self._caller = lambda f: f() > File "/Apps/web2py/applications/init/controllers/ > default.py:testing", line 124, in testing > File "/Apps/web2py/gluon/sql.py", line 3055, in select > query = self._select(*fields, **attributes) > File "/Apps/web2py/gluon/sql.py", line 2947, in _select > raise SyntaxError, 'Set: no tables selected' > SyntaxError: Set: no tables selected > > Whereas: > > rows = db(db.shop.id>0).select() > for row in rows: > print row.company.name, row.address > > Works fine. > > Is this the expected behavior given that I'm using GAE or have I done > something completely wrong? > > Thanks in advance, > Matt -- 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.
