It's probably a good idea to strip any leading/trailing whitespace before
the names are ever inserted in the database.
Anthony
On Wednesday, November 16, 2016 at 9:28:56 AM UTC-5, Richard wrote:
>
> 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.
