Why not use a single request.vars.k with all keywords separated by a
space and then
query = reduce(lambda a,b:a|b,[db.sarua.keywords.like('%'+k
+'%') for k in request.vars.k.split()])
On Mar 5, 6:21 am, Johann Spies <[email protected]> wrote:
> I have a form where the customer can type one keyword on each of the
> five fields (the first field may not be empty). From these keywords I
> have to build a query that would use .like('%' keyword'%') search in
> at least two fields in the database.
>
> I am trying something like this:
>
> k1 = request.vars.k1
> k2 = request.vars.k2
> k3 = request.vars.k3
> k4 = request.vars.k4
> k5 = request.vars.k5
> s = '%' + k1 + '%'
> query = (db.sarua.title.like(s)|db.sarua.keywords.like(s))
>
> The only way to do the rest looks to me something like this:
>
> if k2:
> ... building a longer query
> if k3:
> ... add to k2-query
>
> Is there a better way? Maybe building a query to test a list of
> strings separately against the different fields.
>
> Johann
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
