I would like to do something like SELECT * FROM MyTable WHERE input_date >= start_date AND input_date <= end_date
but I get Inequality Filters Are Allowed On One Property Only See http://appengine-cookbook.appspot.com/recipe/how-to-query-by-date-range/ Well, guess i'll have to do the script then On Dec 4, 3:43 pm, Eli Jones <[email protected]> wrote: > What do you mean by double filter? > > What exactly is the select/query you want to run? > > What does your Model look like? > > From your description of the issue, it's hard to tell what you mean by > "double filter". > > Thanks for clarification. > > > > On Fri, Dec 4, 2009 at 9:40 AM, sofia <[email protected]> wrote: > > Hi, > > > I have a model that I need to filter by date, start and end date. It > > has a DateTime property to which this double filter was going to be > > applied but I've since found out that this isn't possible in app > > engine. So now I want to add a new field with only the year and month, > > something like 200912 and will only filter by month. > > > So if i have a 1000 rows, like this > > > title | date_created | year_month > > a string | 2009-10-12 00:00:00 | > > the string | 2009-09-22 00:00:00 | > > > how do i update in one go all rows so that i end up with this: > > > title | date_created | year_month > > a string | 2009-10-12 00:00:00 | 200910 > > the string | 2009-09-22 00:00:00 | 200909 > > > Is there any way to do this, or do I have to create a script that > > fetches each row one by one and updates the field accordingly? > > > Thanks, > > > Sofia > > > -- > > > 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]<google-appengine%2Bunsubscrib > > [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.
