Hi People,

I have a simple query like this:

SELECT * FROM Link WHERE createddate > :StartDate AND createddate
< :EndDate ORDER BY rating_average DESC, createddate DESC

Obviously I cant do this and if I swtch the order of the rating and
the created date it doesn't work the way I would like, any
suggestions / tricky ways of getting around it? idealy I want the
query to be:

SELECT * FROM Link WHERE createddate > :StartDate AND createddate
< :EndDate ORDER BY rating_average DESC

Only thing I could think of was in memory sorting, this doesn't work
too well with paging and the 1000 item result limit.

I'm really enjoying the app engine developing in general (loving
python) but the datastore is a tad frustrating so far.

Thanks!
Maxus

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to