There are some slight differences with queries on the SDK vs production. Your issue looks an awful lot like 798: http://code.google.com/p/googleappengine/issues/detail?id=798
On production at least one item in the list must match all of the inequality filters. So, like djidjadji said, your query can not return a result. Try making the lower bound 1279592999, or use a weak inequality (>=), Robert On Sun, Oct 31, 2010 at 13:31, johnterran <[email protected]> wrote: > This works in the development environment... > Basically, since we can't use inequality filter on more than 1 > property, so I used a list to check for range. > I followed the work around for range query from > http://appengine-cookbook.appspot.com/recipe/how-to-query-by-date-range > > If this doesn't work in production, how do I do a range query on > BigTable (use 2 inequality filters)? > > Thanks > John > > On Oct 31, 8:56 am, djidjadji <[email protected]> wrote: >> Both your inequality long values are the same >> timeRange > 1279593000 >> timeRange <= 1279593000 >> >> No timeRange value will ever match these two criteria >> >> 2010/10/31 johnterran <[email protected]>: >> >> >> >> >> >> >> >> >> >> > Hi, >> >> > I am using this GQL range query and it works for me in the >> > development. >> > But once i deployed it to production, the query is not working, even >> > from the admin console. >> > And i can see the data, and it is within range.. >> > ie. >> > SELECT * from Event WHERE timeRange > 1279593000 AND timeRange <= >> > 1279593000 >> >> > class Event(db.Model): >> > name = db.StringProperty(required=True) >> > timeRange = db.ListProperty(long) >> >> > one sample data >> > Event.name Test >> > Event.timeRange [1279591200L, 1279594800L] >> >> > Why does this work in development but not in production? >> > I am running 1.3.7 in development due to datastore error in 1.3.8 on >> > win7 >> >> > thanks >> > John >> >> > -- >> > 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 >> > athttp://groups.google.com/group/google-appengine?hl=en. > > -- > 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. > > -- 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.
