[google-appengine] Re: using keys in an IN statement

2009-03-03 Thread pedepy
uhah yea i believe i am isnt the proper syntax WHERE property IN (foo, foo, foo) ? On Mar 3, 2:38 am, ryan ryanb+appeng...@google.com wrote: On Mar 1, 11:06 am, pedepy paul.ro...@gmail.com wrote: I would like to fetch results only against a particular subset of keys. I'm trying to use

[google-appengine] Re: using keys in an IN statement

2009-03-03 Thread ryan
On Mar 3, 12:26 pm, pedepy paul.ro...@gmail.com wrote: isnt the proper syntax WHERE property IN (foo, foo, foo) ? if you're providing a list of constants, yes. if you're using a bound parameter, though, like in your original post, you should omit the parentheses. having said that, it looks

[google-appengine] Re: using keys in an IN statement

2009-03-03 Thread Devel63
I just implemented something like this, and while it ran fine on the dev_server, I noticed that it defined in index.yaml a new index for every observed number of items in the IN set. Since I was approaching the 30 limit, and had other varying elements of the query, this caused an explosion of

[google-appengine] Re: using keys in an IN statement

2009-03-03 Thread Andy Freeman
This was previously mentioned (no resolution/answer) in http://groups.google.com/group/google-appengine/browse_thread/thread/1285c272c0e1b62a On Mar 3, 7:36 pm, Devel63 danstic...@gmail.com wrote: I just implemented something like this, and while it ran fine on the dev_server, I noticed that

[google-appengine] Re: using keys in an IN statement

2009-03-03 Thread ryan
On Mar 3, 10:23 pm, Andy Freeman ana...@earthlink.net wrote: This was previously mentioned (no resolution/answer) inhttp://groups.google.com/group/google-appengine/browse_thread/thread/... thanks for the nudge. heading over to answer... --~--~-~--~~~---~--~~

[google-appengine] Re: using keys in an IN statement

2009-03-02 Thread ryan
On Mar 1, 11:06 am, pedepy paul.ro...@gmail.com wrote: I would like to fetch results only against a particular subset of keys. I'm trying to use 'WHERE __key__ IN (:1), list_of_keys ... the gql object accepts that as a valid query, but returns no result.. hmm, __key__ IN ... works for me.