would you also need to do search_term.lower() to make that work?
On Fri, Dec 11, 2009 at 9:40 PM, Thadeus Burgess <thade...@thadeusb.com> wrote:
> db(db.table.field.lower().like("%"+search_term+"%"))
>
> -Thadeus
>
>
>
>
>
> On Fri, Dec 11, 2009 at 10:35 PM, Wes James <compte...@gmail.com> 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 web...@googlegroups.com.
>> To unsubscribe from this group, send email to
>> web2py+unsubscr...@googlegroups.com.
>> 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 web...@googlegroups.com.
> To unsubscribe from this group, send email to
> web2py+unsubscr...@googlegroups.com.
> 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 web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
