Hi Bemmu,
On Mon, Aug 10, 2009 at 3:39 PM, Bemmu<bemmu....@gmail.com> wrote:
>
> If I just know a key, how do I query by that in the admin console data
> viewer?
>
> My keys are people, so if I get complaints about mistakes in user
> data, it would be convenient to pull up that user's data by key. I've
> tried doing the following:
>
> SELECT * FROM User WHERE __key__ = 'myspace.com:472071387'
>
> Result is that I get a page that says "Server Error - A server error
> has occurred."
>
> I also tried
>
> SELECT * FROM User WHERE __key__ = KEY('myspace.com:472071387')
>
> And got same error. Finally I tried
>
> SELECT * FROM User WHERE __key__ = KEY(myspace.com:472071387)
>
> And this time I got complaint of invalid GQL query. So how should I be
> doing this query or is it even possible?
None of these are keys - they are only key _names_. A key consists of
a type as well as a name or ID (and possibly the type & name/id pairs
of parent entities). In your case, you want to do something like this:
SELECT * FROM User WHERE __key__ = KEY('User', 'myspace.com:472071387')
-Nick Johnson
> >
>
--
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 google-appengine@googlegroups.com
To unsubscribe from this group, send email to
google-appengine+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en
-~----------~----~----~----~------~----~------~--~---
