If you want to compare lowercase you have to store the value lowercase
in the object.
GQL != SQL You can't do more then described on the GQL reference page.
You have to traverse (get) all you current objects and make the field
login lowercase and store the object back and as such update the index
for login-field.
2010/3/21 vchalmel <groupeprojeten...@gmail.com>:
> Hi !
>
> I wonder how to compare a String stored in a datastore entity (field
> "login") to an entry (also named login) considering their lowercase
> version :
> - I tried : "SELECT count(this) FROM "+Gestionnaire.class.getName()+"
> WHERE LowerCase(login)== LowerCase('"+login+"')" which throws an
> exception
>
> I have another problem with this query, I don't want to exclude the
> one-character login like, maybe "1", but this also fires an exception
> ( java.lang.Character cannot be cast to
> com.google.appengine.api.datastore.Key )
>
> --
> 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-appeng...@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.
>
>
--
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-appeng...@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.
