Hi Sergiy, I suspect that the reason that you see no results, it that both your <= and your >= query have the same rvalue (in other words ipRange <= x and ipRange >= x) which would reduce to an exact match = query. If there is an entity which contains 2398436096 somewhere in the ipRange list, then it should appear, are there any in the datastore? You will see results if the >= value is less than the <= value and some entities contain ipRange list members in the range.
Happy coding, Jeff On Jun 3, 12:20 pm, mega_apps <mega_a...@yahoo.com> wrote: > Jeff, > > >Unless I'm misunderstanding the structure of > > your entities. What does a GeoIpBlock look like? > > class GeoIpBlock(db.Model): > ipRange = db.ListProperty(int) > locId = db.IntegerProperty(indexed=False) > > > Well, my first question may seem a bit obvious but, are you certain that an > > entity is present in the App Engine datastore with ipRange of 2398436100? > > When I do following: > > SELECT * FROM GeoIpBlock where ipRange >= 2398436100 > -note only one inequality > > I get first 1000 results, with the first result: > Ip-1973013 [2398436096L, 2398436351L] 14997 > > Which is actually what I need... except that when I narrow it down and > add second inequality I brake it, as: > > SELECT * FROM GeoIpBlock where ipRange >= 2398436100 and ipRange <= > 2398436100 > > returns no results. > > Thanks, > Sergiy. > > On Jun 3, 2:25 pm, "Jeff S (Google)" <j...@google.com> wrote: > > > Hi mega_apps, > > > Well, my first question may seem a bit obvious but, are you certain that an > > entity is present in the App Engine datastore with ipRange of 2398436100? > > Also it seems like your query is equivalent to an = query. x <= y and x >= y > > would be the same as x = y. Unless I'm misunderstanding the structure of > > your entities. What does a GeoIpBlock look like? > > > Cheers, > > > Jeff > > > On Wed, Jun 3, 2009 at 8:23 AM, mega_apps <mega_a...@yahoo.com> wrote: > > > > Jeff, thanks for quick reply. > > > > >What is the ID of this application? > > > My app id is temptationads. > > > > >several of the GeoIpBlock entities have a value for a property which is > > > not of the expected type. > > > It seems that indexes are being build/rebuild and Data Viewer is not > > > crashing anymore. > > > > But it still doesn't work completely: > > > > SELECT * FROM GeoIpBlock where ipRange >= 50331648 and ipRange <= > > > 50331648 > > > > Produces 1 result now in production and dev > > > > SELECT * FROM GeoIpBlock where ipRange >= 2398436100 and ipRange <= > > > 2398436100 > > > > Produces _no_ results in production and 1 result in dev. > > > > Any ideas? > > > > On Jun 2, 4:44 pm, "Jeff S (Google)" <j...@google.com> wrote: > > > > Hi mega_apps, > > > > > My first guess would be that one or several of the GeoIpBlock entities > > > have > > > > a value for a property which is not of the expected type. What is the ID > > > of > > > > this application? > > > > > Thank you, > > > > > Jeff > > > > > On Sat, May 30, 2009 at 5:33 PM, mega_apps <mega_a...@yahoo.com> wrote: > > > > > > I am getting 500 errors when executing valid GQL queries to the > > > > > datastore using the Data Viewer: > > > > > > SELECT * FROM GeoIpBlock where ipRange >= 0 > > > > > > The same queries work fine in development. > > > > > > I uploaded over 3,000,000 GeoIpBlock entities and had to purchase > > > > > additional Storage when growing indexes hit 1G. Could corrupted > > > > > indexes cause this? > > > > > > . > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appengine@googlegroups.com To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---
