Sure I can! ;)
Here it is:
ERROR 2012-09-30 18:04:57,520 restricted.py:54] In FILE:
> /home/dapids/webdev/backinterface/web2py/applications/backinterface/controllers/default.py
>
> Traceback (most recent call last):
> File "/home/dapids/webdev/backinterface/web2py/gluon/restricted.py",
> line 209, in restricted
> exec ccode in environment
> File
> "/home/dapids/webdev/backinterface/web2py/applications/backinterface/controllers/default.py",
> line 86, in <module>
> File "/home/dapids/webdev/backinterface/web2py/gluon/globals.py", line
> 186, in <lambda>
> self._caller = lambda f: f()
> File
> "/home/dapids/webdev/backinterface/web2py/applications/backinterface/controllers/default.py",
> line 24, in editnews
> grid = SQLFORM.grid(db.news)
> File "/home/dapids/webdev/backinterface/web2py/gluon/sqlhtml.py", line
> 2042, in grid
> cacheable=True,*table_fields)
> File "/home/dapids/webdev/backinterface/web2py/gluon/dal.py", line 8719,
> in select
> return adapter.select(self.query,fields,attributes)
> File "/home/dapids/webdev/backinterface/web2py/gluon/dal.py", line 4546,
> in select
> for t in fields] for item in items]
> File
> "/home/dapids/google_appengine/google/appengine/ext/db/__init__.py", line
> 2082, in __iter__
> return self.run()
> File
> "/home/dapids/google_appengine/google/appengine/ext/db/__init__.py", line
> 2063, in run
> raw_query = self._get_query()
> File
> "/home/dapids/google_appengine/google/appengine/ext/db/__init__.py", line
> 2459, in _get_query
> _app=self._app)
> File "/home/dapids/google_appengine/google/appengine/api/datastore.py",
> line 1315, in __init__
> self.update(filters)
> File "/home/dapids/google_appengine/google/appengine/api/datastore.py",
> line 1764, in update
> self.__setitem__(filter, value)
> File "/home/dapids/google_appengine/google/appengine/api/datastore.py",
> line 1708, in __setitem__
> match = self._CheckFilter(filter, value)
> File "/home/dapids/google_appengine/google/appengine/api/datastore.py",
> line 1847, in _CheckFilter
> (datastore_types.KEY_SPECIAL_PROPERTY, value, typename(value)))
> BadFilterError: invalid filter: __key__ filter value must be a Key;
> received None (a NoneType).
>
Thanks for your help Massimo.
Cheers,
David
On 30 September 2012 19:40, Massimo Di Pierro <massimo.dipie...@gmail.com>wrote:
> Can you please post the entire traceback?
>
> Massimo
>
>
> On Sunday, 30 September 2012 11:52:57 UTC-5, David Sorrentino wrote:
>>
>> Hi there! :)
>>
>> I'm trying to exploit the power of SQLFORM.grid with GAE but I'm having
>> some troubles.
>> All I want to do is to have a grid from a table (seems to be simple
>> reading the infinite examples on the web).
>>
>> Here my table definition:
>>
>> db.define_table('news',
>>> Field('title'),
>>> Field('body', 'text')
>>> )
>>>
>>
>> Here the controller:
>>
>> @auth.requires_login()
>>> def editnews():
>>> grid = SQLFORM.grid(db.news)
>>> return dict(grid=grid)
>>>
>>
>> And here the view:
>>
>> {{extend 'layout.html'}}
>>> <p>{{=grid}}</p>
>>>
>>
>> Unfortunately when I load the view I get this error:
>>
>> BadFilterError: invalid filter: __key__ filter value must be a Key;
>>> received None (a NoneType).
>>>
>>
>> The errors seems to be in the definition of the grid, but I can't
>> understand what's wrong.
>> Can somebody help me? :)
>>
>> Cheers,
>> David
>>
> --
>
>
>
>
--
