t2 work. the puppy app does not. you have to break the select into
multiple selects.

Massimo

On Dec 29, 12:28 am, "Miguel Goncalves" <goncalvesmig...@gmail.com>
wrote:
> So I suppose the JOIN in the puppy tutorial is the "friendship" declaration.
>
> What is the recommended pattern to "simulate" a JOIN in order to run on the
> GAE?
>
> Thanks
> Miguel
>
> On Fri, Dec 26, 2008 at 2:54 PM, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > you cannot do JOINS on GAE. The puppy tutorial does a JOIN.
>
> > On Dec 26, 2:11 pm, Miguel <goncalvesmig...@gmail.com> wrote:
> > > Hi
>
> > > I installed web2py and the T2 plugin. I also when through the puppies
> > > tutorial and everything works fine locally when I am running web2py
> > > server.
>
> > > However when I run GAE locally (dev_appserver.py) I get the following
> > > error:
> > >   Internal Error
> > >   Ticket Issued: Unknown
>
> > > What am I missing?
> > > Bellow is the command line log of GAE:
>
> > > G:\google_appengine>dev_appserver.py crbox
> > > INFO     2008-12-26 19:57:44,191 appcfg.py] Server:
> > > appengine.google.com
> > > INFO     2008-12-26 19:57:44,216 appcfg.py] Checking for updates to
> > > the SDK.
> > > INFO     2008-12-26 19:57:44,476 appcfg.py] The SDK is up to date.
> > > WARNING  2008-12-26 19:57:44,726 dev_appserver.py] Could not
> > > initialize images API; you are likely missing the Python "PIL" module
> > > . ImportError: No module named PIL
> > > INFO     2008-12-26 19:57:45,052 dev_appserver_main.py] Running
> > > application crbox on port 8080:http://localhost:8080
> > > WARNING  2008-12-26 20:03:13,944 portalocker.py] no file locking
> > > WARNING  2008-12-26 20:03:19,069 cache.py] unable to import dbhash
> > > WARNING  2008-12-26 20:03:20,520 compileapp.py] unable to import
> > > py_compile
> > > WARNING  2008-12-26 20:03:22,191 main.py] unable to import wsgiserver
> > > INFO     2008-12-26 20:03:28,384 dev_appserver.py] "GET / HTTP/1.1"
> > > 303 -
> > > INFO     2008-12-26 20:03:28,684 dev_appserver_index.py] Updating G:
> > > \google_appengine\crbox\index.yaml
> > > WARNING  2008-12-26 20:03:28,885 cache.py] no cache.disk
> > > ERROR    2008-12-26 20:03:30,119 main.py] Traceback (most recent call
> > > last):
> > >   File "G:\google_appengine\crbox\gluon\restricted.py", line 62, in
> > > restricted
> > >     exec ccode in environment
> > >   File "G:\google_appengine\crbox\applications\welcome/models/db.py",
> > > line 60, in <module>
> > >     friendship=db.t2_person.id==db.link.person_id and
> > > db.company.id==db.link.company_id
> > >   File "G:\google_appengine\crbox\gluon\contrib\gql.py", line 205, in
> > > __eq__
> > >     def __eq__(self,value): return SQLQuery(self,'=',value)
> > >   File "G:\google_appengine\crbox\gluon\contrib\gql.py", line 321, in
> > > __init__
> > >     raise SyntaxError, 'SQLQuery: right side of filter must be a value
> > > or entity'
> > > SyntaxError: SQLQuery: right side of filter must be a value or entity
>
> > > INFO     2008-12-26 20:03:30,354 dev_appserver.py] "GET /welcome/
> > > default/index HTTP/1.1" 200 -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@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