you can do this neat little trick:
Select * From table Where __key__ = Key('table',22)
If the id was really a key_name, then you'd use '22' instead of an int.
On Thu, Mar 18, 2010 at 5:25 PM, observer247 <[email protected]> wrote:
> While using the datastore viewer, to find a particular record, I use a
> gql query, for eg:
>
> Select * from table where name = 'myname'
>
>
> or to sort it in descending order:
>
> Select * from table ORDER BY score DESC
>
> My question is how to I find a record with id = 22
>
> Also how do I sort and find out the last added entry. (so I would sort
> it by id in desc order).
>
> Thanks for reading.
>
> --
> 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%[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.
