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.


Reply via email to