I found my answer..
select * from Employee where __key__ = KEY('Employee',1), without the
quotes around 1 worked.
The other thing I was doing incorrectly, was that for the KEY() function, I
need to pass the long string that is generated
SELECT * FROM Employee where __key__ =
KEY('aghzaGFzZWR2zzIUCxIIRW1wbG95ZWUiBlNoYWhlZAw')
2009/12/30 newbie100 <[email protected]>
> Hi,
>
> I am using the Java Admin Consoles DataStore Explorer, and would like
> to know if its possible to query
> an object using the Key/Id ?
>
> If I run a query
>
> select * from Employee,
>
> I get a row back with id=1
>
> If I try something like
>
> select * from Employee where __key__ = KEY('1'), I get an
> error (Incorrect padding)
>
> select * from Employee where __key__ = KEY('Empolyee,'1'),
> I get no data back
>
> Can someone please tell me what the correct syntax is, from the web
> based data explorer (production)
>
> Thanks
>
> --
>
> 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.
