Thadeus,
thx for the tip! this is what works:
db(db.table.field.lower().like("%"+search_term.lower()+"%"))
-wes
On Fri, Dec 11, 2009 at 9:43 PM, Wes James <[email protected]> wrote:
> would you also need to do search_term.lower() to make that work?
>
> On Fri, Dec 11, 2009 at 9:40 PM, Thadeus Burgess <[email protected]>
> wrote:
>> db(db.table.field.lower().like("%"+search_term+"%"))
>>
>> -Thadeus
>>
>>
>>
>>
>>
>> On Fri, Dec 11, 2009 at 10:35 PM, Wes James <[email protected]> wrote:
>>> I have been doing initial work with sqlite. In a search all items
>>> have been appearing in the results. I am moving to postgresql and now
>>> queries are case sensitive. Is there a simple way to get a case
>>> insensitive query with web2py/postgresql?
>>>
>>> thx,
>>>
>>> -wes
>>>
>>> --
>>>
>>> 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.
>>>
>>>
>>>
>>
>> --
>>
>> 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.
>>
>>
>>
>
--
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.
