Hi Mike, If you check the logs in your admin console, you can see the exception that is being raised. Judging by your code snippet, it's probably telling you that you need a composite index for that query.
-Nick Johnson On Sun, May 17, 2009 at 6:32 AM, Mike Cantelon <[email protected]> wrote: > > I've got a weird problem where if I filter a DateTimeProperty with > either a "<" or ">" I get a 500 server error, but if I filter with "=" > I don't get the error. Any advice would be welcome! > > Here's the code that *doesn't* result in the error: > > class Session(db.Model): > fcid = db.StringProperty() > name = db.StringProperty() > created = db.DateTimeProperty(auto_now_add=True) > > def test_case(): > # kill existing sessions > q = db.GqlQuery("SELECT __key__ FROM Session") > results = q.fetch(10) > db.delete(results) > > # make new session > session = Session() > session.fcid = 'mike' > session.name = 'Mike Cantelon' > session.put() > > # so now if we get all sessions with a created greater than an hour > ago > # we should get one > hour = datetime.timedelta(hours=1) > date_hour_ago = datetime.datetime.today() - hour > sessions = Session.all() > sessions.filter("fcid =", 'mike') > sessions.filter("created =", date_hour_ago) > > for session in sessions: > print session.name > print session.created > > Here's the code that *does* result in the error (identical except for > the comparison operator): > > class Session(db.Model): > fcid = db.StringProperty() > name = db.StringProperty() > created = db.DateTimeProperty(auto_now_add=True) > > def test_case(): > # kill existing sessions > q = db.GqlQuery("SELECT __key__ FROM Session") > results = q.fetch(10) > db.delete(results) > > # make new session > session = Session() > session.fcid = 'mike' > session.name = 'Mike Cantelon' > session.put() > > # so now if we get all sessions with a created greater than an hour > ago > # we should get one > hour = datetime.timedelta(hours=1) > date_hour_ago = datetime.datetime.today() - hour > sessions = Session.all() > sessions.filter("fcid =", 'mike') > sessions.filter("created >", date_hour_ago) > > for session in sessions: > print session.name > print session.created > > Any advice on what is causing this would be welcome! > > Mike > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
