Thanks. I am not sure where I got the syntax I was using. Also, I find it odd that the syntax that shouldn't work actually does when working with a sqlite db.
On Dec 15, 7:09 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > This line > > db(db.word.insert(word = 'aa')) > > is not a valid DAL syntax. > > db.word.insert(word = 'aa') is correct and > db(query).select() > > is correct but the result of the insert is not a query. > > Massimo > > On Dec 15, 7:11 pm, Hillman <hillma...@gmail.com> wrote: > > > I get the following error: > > > Traceback (most recent call last): > > File "C:\DropBox\My Dropbox\Programming Projects\Python > > \google_appengine\hillmanwork\gluon\restricted.py", line 173, in > > restricted > > exec ccode in environment > > File "C:\DropBox\My Dropbox\Programming Projects\Python > > \google_appengine\hillmanwork\applications\default/controllers/ > > word0.py:index", line 21218, in <module> > > File "C:\DropBox\My Dropbox\Programming Projects\Python > > \google_appengine\hillmanwork\gluon\globals.py", line 96, in <lambda> > > self._caller = lambda f: f() > > File "C:\DropBox\My Dropbox\Programming Projects\Python > > \google_appengine\hillmanwork\applications\default/controllers/ > > word0.py:index", line 2, in index > > File "C:\DropBox\My Dropbox\Programming Projects\Python > > \google_appengine\hillmanwork\gluon\contrib\gql.py", line 137, in > > __call__ > > return Set(self, where) > > File "C:\DropBox\My Dropbox\Programming Projects\Python > > \google_appengine\hillmanwork\gluon\contrib\gql.py", line 573, in > > __init__ > > self._tables = [filter.left._tablename for filter in > > where.filters] > > TypeError: 'NoneType' object is not iterable > > > when executing the following line of code: > > > db(db.word.insert(word = 'aa')) > > > The table definition is: > > > db.define_table('word', > > SQLField('word', 'string')) > > > I am running web2py version 1.74.1, by the way. > > > Everything works fine on the local sqlite db, but not when uploaded to > > GAE, or run with the GAE local launcher. > > > Any hints? > > > Thanks. > > -- 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.