Hi, You should try querying them all (so that you don't have to create an invalid query) via a Java program and then check the value of the property once the object is instantiated in order to issue a delete if the prop value is wrong.
You may have to do this via chained queued tasks if your data is big. regards didier On Apr 7, 8:53 pm, Ben <bencarl...@gmail.com> wrote: > Hello, > > I have a strange problem in the app engine data viewer (admin tools). > I have entities in my app that have an email property, but the value > of email is ''... blank. This is apparently invalid, as when I browse > all entities with the email property, I get an error. > > I then try to query: SELECT * FROM User WHERE email = '' and get the > error: "email must not be empty." I then try to query in reverse: > SELECT * FROM User WHERE email != '' and I can browse the entities > with no issues. > > How can I delete the entities with blank emails, when I cannot query > on it being blank? > > I have a similar issue with URLs. > > Thanks! > > -Ben > > http://www.liink.ithttp://about.me/benjaminc -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to google-appengine-java@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.