THANKS matt and massimo!! i did not report this cause i thought it
was not supported on GAE! you guys just made my week!
cfh
On Apr 6, 11:10 pm, Matt <mjwat...@gmail.com> wrote:
> Yup all good... Working now.
>
> Thanks again,
> Matt
>
> On Apr 7, 5:56 pm, Matt <mjwat...@gmail.com> wrote:
>
> > Massimo,
>
> > Ok Cool... Thanks for fixing it so quickly.
>
> > Will checkout the trunk,
> > Matt
>
> > On Apr 7, 5:29 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > 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 <mjwat...@gmail.com> 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 web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
