Hi Cyprian,

On Tue, Aug 18, 2009 at 1:15 PM, Cyprian <[email protected]>wrote:

>
> Same for me,
> following queries work fine form dataviewer console:
> SELECT * FROM RSS WHERE title<''
> SELECT * FROM RSS WHERE ORDER BY date2 DESC
>
> and that cause an error:
> SELECT * FROM RSS WHERE title<'' ORDER BY date2 DESC


This is not a valid query: If you have inequality filters on a property,
that property must also be used as your first sort order.

-Nick Johnson


>
>
> "Server Error
> A server error has occurred."
>
> APP ID: dhsrss
>
> BR
> Cyprian
>
> On 6 Sie, 13:19, niklasr <[email protected]> wrote:
> > Hello
> > Recently there were results I can't understand from the dataviewer
> > console:
> > SELECT * FROM Article order by added desc
> > #The above works to view entities
> > SELECT * FROM Article where published=True
> > #The above works to view lists entities
> > The following however generates a server error
> > SELECT * FROM Article where published=True order by added desc
> > #Server Error
> > It happens with 2 independent applications. The queries used to work.
> > Please inform what could be the case.
> > Thank you
> > _______
> > NickRTZ
>
> >
>


-- 
Nick Johnson, Developer Programs Engineer, App Engine

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