Re: [appengine-java] Re: case sensitivity
Resistance is futile. Kris wrote: Thanks Rusty, I've already searched there and have seen the suggestions. I have been having a hard time believing that there is no way to do this when using google app engine but am more or less convinced at this point. On Nov 16, 6:06 pm, Rusty Wright rwright.li...@gmail.com wrote: http://groups.google.com/group/google-appengine-java/search?group=goo... Kris wrote: I'm more concerned about the proper way to do this generically. I can't realistically store duplicates of every string based field that I may want to search for. On Nov 16, 11:36 am, Rusty Wright rwright.li...@gmail.com wrote: The recommended approach is to store the userName in all lower case, as an additional field/column, and then do the toLowerCase on the incoming parameter user name when you do the query and use that field/column that was stored in lower case. Kris wrote: Is there any way to perform a JDO query on google app engine using a case insensitive string comparison? e.g. For example, Query query = pm.newQuery(User.class, userName.toLowerCase() == user password == pass); query.declareParameters(String user, String pass); query.setUnique(true); User user = (User) query.execute(userName.toLowerCase(), password); Of course GAE does not support the usage of toLowerCase() in the filter string. There's probably a terribly simple way to do this that I'm just not aware of. -- 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-j...@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com. For more options, visit this group athttp://groups.google.com/group/google-appengine-java?hl=. -- 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-j...@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com. For more options, visit this group athttp://groups.google.com/group/google-appengine-java?hl=. -- 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-j...@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=. -- 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-j...@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=.
Re: [appengine-java] Re: case sensitivity
Hi. I agree with Kris in that this feature is absolutely necessary. However, maybe this feature will be included in this other more general issue http://code.google.com/p/googleappengine/issues/detail?id=217 . Maybe someone from Google can tell us what's the best way to do it, or whether we can expect it soon by being included in some other issue. Regards, Esteban On Tue, Nov 17, 2009 at 5:19 PM, Rusty Wright rwright.li...@gmail.comwrote: Resistance is futile. Kris wrote: Thanks Rusty, I've already searched there and have seen the suggestions. I have been having a hard time believing that there is no way to do this when using google app engine but am more or less convinced at this point. On Nov 16, 6:06 pm, Rusty Wright rwright.li...@gmail.com wrote: http://groups.google.com/group/google-appengine-java/search?group=goo. .. Kris wrote: I'm more concerned about the proper way to do this generically. I can't realistically store duplicates of every string based field that I may want to search for. On Nov 16, 11:36 am, Rusty Wright rwright.li...@gmail.com wrote: The recommended approach is to store the userName in all lower case, as an additional field/column, and then do the toLowerCase on the incoming parameter user name when you do the query and use that field/column that was stored in lower case. Kris wrote: Is there any way to perform a JDO query on google app engine using a case insensitive string comparison? e.g. For example, Query query = pm.newQuery(User.class, userName.toLowerCase() == user password == pass); query.declareParameters(String user, String pass); query.setUnique(true); User user = (User) query.execute(userName.toLowerCase(), password); Of course GAE does not support the usage of toLowerCase() in the filter string. There's probably a terribly simple way to do this that I'm just not aware of. -- 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-j...@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.comgoogle-appengine-java%2bunsubscr...@googlegroups.com . For more options, visit this group athttp:// groups.google.com/group/google-appengine-java?hl=. -- 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-j...@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.comgoogle-appengine-java%2bunsubscr...@googlegroups.com . For more options, visit this group athttp:// groups.google.com/group/google-appengine-java?hl=. -- 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-j...@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.comgoogle-appengine-java%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=. -- 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-j...@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.comgoogle-appengine-java%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=. -- 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-j...@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=.
Re: [appengine-java] Re: case sensitivity
http://groups.google.com/group/google-appengine-java/search?group=google-appengine-javaq=lowercase+queryqt_g=Search+this+group Kris wrote: I'm more concerned about the proper way to do this generically. I can't realistically store duplicates of every string based field that I may want to search for. On Nov 16, 11:36 am, Rusty Wright rwright.li...@gmail.com wrote: The recommended approach is to store the userName in all lower case, as an additional field/column, and then do the toLowerCase on the incoming parameter user name when you do the query and use that field/column that was stored in lower case. Kris wrote: Is there any way to perform a JDO query on google app engine using a case insensitive string comparison? e.g. For example, Query query = pm.newQuery(User.class, userName.toLowerCase() == user password == pass); query.declareParameters(String user, String pass); query.setUnique(true); User user = (User) query.execute(userName.toLowerCase(), password); Of course GAE does not support the usage of toLowerCase() in the filter string. There's probably a terribly simple way to do this that I'm just not aware of. -- 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-j...@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com. For more options, visit this group athttp://groups.google.com/group/google-appengine-java?hl=. -- 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-j...@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=. -- 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-j...@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=.