[google-appengine] questions on datastore (lowercase comparison / one character String )

2010-03-22 Thread vchalmel
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

Re: [google-appengine] questions on datastore (lowercase comparison / one character String )

2010-03-22 Thread djidjadji
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