Here what I usually do for search in user field name :
search_val = request.vars.txtSearch
rows = db(((db.auth_user.registration_key != 'disabled') |
(db.auth_user.registration_key == None)) &
(db.auth_user.first_name.lower().like('%{0}%'.format(search_val.lower()))) |
((db.auth_user.registration_key != 'disabled') |
(db.auth_user.registration_key == None)) &
(db.auth_user.last_name.lower().like('%{0}%'.format(search_val.lower())))
).select(db.auth_user.id, db.auth_user.first_name,
db.auth_user.last_name, db.auth_user.username,
orderby=[db.auth_user.first_name,
db.auth_user.last_name])
You can do .lower().strip() to be sure, it important that you made .lower()
on "both side" of the query, search value and database value...
Richard
On Wed, Nov 16, 2016 at 8:11 AM, Richard Vézina <[email protected]
> wrote:
> .strip()
>
> Richard
>
> On Wed, Nov 16, 2016 at 2:29 AM, 'Annet' via web2py-users <
> [email protected]> wrote:
>
>> I have a form in which the user enter his name, for example: 'Thompson,
>> Brian'
>>
>> When I execute the following query:
>>
>> rowset = db(db.vtx_vertex.name.ilike(nameform.vars.name))
>>
>> This query return the correct result.
>>
>> However, when db.vtx_vertex.name is 'Thompson, Brian ' (a space after
>> Brian)
>> and nameform.vars.name is 'Thompson, Brian ' as well, the query does not
>> return a result.
>>
>> Why not, and how can I fix this problem?
>>
>> Kind regards,
>>
>> Annet
>>
>> --
>> 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.
>>
>
>
--
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.
