[Milfriosc]

Hello,

 

I'm french (thank's google traduction and sorry for my poor language) and newbie ... so this is my question :

I use the theme flexigrid but when i search "sport" there is no result because this word has a uppercase ("Sport")  in my database.

Have you a idea to solve this problem ?

 

Thank's a lot

[Amit Shah]

Hi Milfriosc,

 

There is a hax around the same. What you can do is just replace $_REQUEST['keyword'] = strtolower($_REQUEST['keyword']) 

 

i just gave the example - this might not be correct.. variable .. but clears the concept

Also dont do it blindly.. understand when u need to do it..!! so it wont give error... .probably - check if the parameter exists .. if it dose - change it ... !

[Milfriosc]

Hi Amit Shah,

 

I use postgresql with this files http://www.geotests.net/blog/article/grocerycrud-developper-rapidement-une-application-web-en-php

After some tests, i've to change the function "protected function _like" of DB_query_builder.php : replace (4x) the LIKE by ILIKE the case insensitive variant for postgres and it's OK  :)

 

thank's for your help

[matteo94s]

Hi! i can't get the postgresql files..... however ILIKE doesn't work