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



--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to