Hi igor,
The IN operator supports keys, but you will probably have to use parameter
substitution in order to achieve it (which is the correct approach when
dealing with user input anyway). For example:
db.GqlQuery("SELECT * FROM Kind WHERE akey IN :1", [key1, key2, key3]).
-Nick Johnson
On Tue, Sep 1, 2009 at 1:32 PM, igor <[email protected]> wrote:
>
> I'd really appreciate some help from experienced guys.
> Does GQL IN() support list from keys?
> Is there a workaround to do it possible?
>
> Thanks
>
> On Aug 26, 8:11 pm, igor <[email protected]> wrote:
> > Hi,
> >
> > I have met issue I can not solve.
> > It does look like current GAE limitation. In case I am right I would
> > like to get fresh idea to prepare workaround.
> >
> > Issue:
> > I have two tables as TABLE1 and TABLE2.
> > TABLE1 has FIELD as reference property to TABLE2
> >
> > I can execute GQL query as "select * from TABLE1 where FIELD=key
> > ('TABLE1', VALUE1)"
> >
> > I would like to do "select * from TABLE1 where FIELD in (key('TABLE1',
> > VALUE1), key('TABLE1', VALUE2))" but get error
> > 'Parse Error: Parameter list requires literal or reference parameter
> > at symbol key'
> >
> > How can I achieve my purpose?
> >
> > Thanks
> >
>
--
Nick Johnson, Developer Programs Engineer, App Engine
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en
-~----------~----~----~----~------~----~------~--~---
