Thanks Barry, I thought about that but got scared off with the docs recommendation not to use this for large sets. However, in reading your post I realize my previous thinking about StringListProperty was all wrong. If i create an extra field on the model and then stuff the username + first_name + last_name in the list field it may just work. I'll give it a try.
thx! On Jan 17, 5:03 pm, "Barry Hunter" <barrybhun...@googlemail.com> wrote: > I beleive you should put the words into a StringListProperty. ie > 'phil', 'gus', 'david' in case of record 3. and search on that field. > Disclaimer: untested - but that is now understand would do it. > > 2009/1/17 Dave <ddev...@gmail.com>: > > > > > > > Hi, > > > This is probably (hopefully!) simple and lack of caffeine has me > > lost. I want to do a query such as: > > > select * from profile where (nickname >= searchname AND nickname < > > searchname+'z') OR (fullname >= searchname AND fullname < searchname > > +'z') > > > my model is: > > > class profile (db.Model): > > nickname = db.StringProperty() > > fullname = db.StringProperty() > > > searchname would be something like 'dav' > > > and the query would pick up all records such that: > > > record 1: nickname = 'david', fullname = 'gus' > > record 2: nickname = 'gus', fullname = 'dave' > > record 3: nickname = 'phil', fullname = 'gus david' *** This may be > > asking for too much. Is it? > > .... > > > Any help is greatly appreciated! > > > thx, > > > Dave > > -- > Barry > > -www.nearby.org.uk-www.geograph.org.uk- --~--~---------~--~----~------------~-------~--~----~ 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-appengine@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 -~----------~----~----~----~------~----~------~--~---
