db(db.table.slp=='value').select() checks that 'value' is in the slp db(db.table.slp<'value').select() checks that at least one element is less than 'value'
db(db.table.slp>'value').select() checks that at least one element if greater then 'value' slp is the name of your field of type StringListProperty. The selected field will be a list. On Feb 18, 5:23 pm, Wes James <compte...@gmail.com> wrote: > I can't find any examples of web2py and gae select with > StringListProperty. Where did you find the example below? I've > looked in the web2py list emails, but I can't see any other working > examples. > > How do you do this with web2py > > pseudo code: > > form(_query) > > def aview > query=request.vars._query > > #how do you do this part with stringlistproperty/gae > rows=db(??).select(??) > > thx, > > -wes > > On Sun, Feb 14, 2010 at 3:57 AM, Richard <richar...@gmail.com> wrote: > > sounds like this will be useful. > > > StringListProperty is a native gae type now supported by web2py: > >http://code.google.com/appengine/docs/python/datastore/typesandproper... > >http://groups.google.com/group/web2py/browse_thread/thread/7d284c9fa4... > > > To get around the like problem you can do something like this: > > Model.all().filter('ngrams >=', word).filter('ngrams <', word + > > u'\ufffd') > > > Check out Thadeus's code for a full example. > > > There's also info how to do this in the docs: > >http://code.google.com/appengine/docs/python/datastore/queriesandinde... > > > Richard > > > On Feb 14, 1:52 pm, Wes James <compte...@gmail.com> wrote: > >> Richard, > > >> Do you have a python example of this? I'll check on > >> StringListProperty also and see how it works. (would this work on > >> gae?) I was trying somthing else since like is not supported, but this > >> might work. I would like this site to provide quick search on > >> anything that would be helpful in building a web2py app. There are a > >> lot of things in tools.py that could go here for instance, and maybe > >> another page with docstrings? Whatever anyone thinks would be > >> helpful. > > >> -wes > > >> On Sat, Feb 13, 2010 at 4:26 PM, Richard <richar...@gmail.com> wrote: > >> > hi wes, > > >> > something like this could be really nice for browsing the function > >> > docstrings. Do you intend to take it further? > > >> > If you use a StringListProperty to store all the ngrams (eg: web2py, > >> > web2p, web2, web, we, w) then it could match partial words. > > >> > Richard > > > -- > > You received this message because you are subscribed to the Google Groups > > "web2py-users" group. > > To post to this group, send email to web...@googlegroups.com. > > To unsubscribe from this group, send email to > > web2py+unsubscr...@googlegroups.com. > > For more options, visit this group > > athttp://groups.google.com/group/web2py?hl=en. -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
