Give me a clue of how to set my search case insensitive for all kind
types?!?
def search():
lname = request.vars.name #form field
q = db.tbl.l_name.like('%'+str(lname)+'%', case_sensitive=False)
grid = _grid(q)
return locals()
This grid returns me all records regardless of case: Black, bLack, blacK
etc.
But if I use for example cyrillic types grid returns case sensitive result.
I've tried contains method:
rows = db(db.tbl.l_name.contains(lname)).select()
- same result.
Is there some magic pie of code to settle the problem?
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
