I figured out how to iterate through request.vars to do a query with multiple .contains(). Now I want to refine that further. Is there a convenient way, when the field being queried is a "string list", to have the contains match only on word boundaries, or do I have accept partial matches and do further filtering on the results (the ROWS object).
By "string list", I mean something similar to how list fields are implemented for sqlite3 backends: the field itself is a string, and the list elements are bounded by a separator. I'm using ',' instead of "|", but you may consider that a quirk for now. If I'm searching for "bit", I don't want "bitter" in the results. If I have to do further filtering, does filter() work on ROWS objects? BTW, I may later on replace this field with an official list-type field. So of course I want deluxe solution that will continue work once I get around to that. /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
