date range in query

[arnie]

For a datastore table with two db.DateTimeProperty columns start_date
and end_date, i need to use a date range in query but below given
query is not working
current_date=datetime.datetime.strptime(self.request.get
('current_date'), '%Y-%m-%dT%H:%M:%S')

db.GqlQuery('SELECT * FROM myTable where start_date>=:cdate and
end_date<=:cdate',cdate=current_date)
in the parameters I am passing current_date=2009-01-10T00:00:00
Should we not compare dates this way?
But this is not working

[N. Rosencrantz]

gql as below works.
SELECT * FROM Image where added > DATETIME(2009,1,1,0,0,0) and added <
DATETIME(2009,2,1,0,0,0)
we must use the integer form (the manual lists b0rked forms)
http://code.google.com/p/googleappengine/issues/detail?id=878
cheers
niklas

[Arun Shanker Prasad]

Hi,

db.GqlQuery('SELECT * FROM myTable where start_date>=:cdate and
end_date<=:cdate',cdate=current_date)

You are trying to use in-equality filters on two properties in a
single query.. Does this not raise an Exception?

There was a post on how to do this more efficiently in the groups
somewhere, but in your case I think you need to query based on one
date from the datastore and do some logic in the view.

> SELECT * FROM Image where added > DATETIME(2009,1,1,0,0,0) and added <
> DATETIME(2009,2,1,0,0,0)

In this example both are applied to the same property.

Thanks,
Arun Shanker Prasad.

On Feb 3, 4:17 pm, niklasr <nikla...@gmail.com> wrote:
> gql as below works.
> SELECT * FROM Image where added > DATETIME(2009,1,1,0,0,0) and added <
> DATETIME(2009,2,1,0,0,0)

> we must use the integer form (the manual lists b0rked forms)http://code.google.com/p/googleappengine/issues/detail?id=878

[arnie]

I have applied the DATETIME method as suggested but unable to use
inequality operator for 2 datetime fields.
I have tried this too
b=db.gqlquery('SELECT * FROM myTable WHERE field1=:val1 and
sdate>=DATETIME(2009,11,20,0,0,0)')
b=b.filter('where edate<=DATETIME(2009,11,20,0,0,0)')
But it does not work. How can I use the comparsion so as to get
results based on using the two table fields?
Thanks

[Garrett Davis]

You are right; you can't have a query with inequality operators on two
fields.
But you can get the result you want, if you add another field to your
object that holds both dates.
There's a new entry in the Google App Engine Cookbook that shows how:
http://appengine-cookbook.appspot.com/recipe/how-to-query-by-date-range

Garrett Davis