Nope, that throws a different error:  Identifier expected at character
1 in "*"

On Nov 9, 10:43 am, Jeff Schwartz <[email protected]> wrote:
> Try:
>
> select * from HospitalData where Version = '1' order by Hospital_Name asc
>
> Jeff
>
>
>
> On Tue, Nov 9, 2010 at 11:16 AM, Rmac <[email protected]> wrote:
> > Thanks Jeff... here you go...
>
> > *The string query supplied to the Query: *
>
> > select from myPackage.HospitalData where Version == '1' order by 
> > Hospital_Name asc
>
> > *The GAE response:*
> > no matching index found..      <datastore-index kind="HospitalData" 
> > ancestor="false" source="manual">
> >         <property name="Version" direction="asc"/>
> >         <property name="Hospital_Name" direction="asc"/>
> >     </datastore-index>
>
> > *Those entries are in the datastore-indexes.xml file and show up on the 
> > admin console as below:*
> > HospitalData
> > Version ▲,Hospital_Name▲,City▲,State▲,ZIP_Code▲,Hospital_Type▲
>
> > If I leave off the "where Version == '1'" the query works (or if I use 
> > Hospital_Name in the where instead).  Currently, all entities have a 
> > property value of 1 for Version.  This shouldn't be so difficult to figure 
> > out for a simple example like this!
>
> > Thanks for any feedback.
>
> >  --
> > 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.
>
> --
> Jeff

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