Jump to content


key-insensitive search not working

grocery crud kei insensitive search function bugs

  • Please log in to reply
No replies to this topic

#1 matteo94s

matteo94s

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 26 October 2018 - 07:09 AM

Hi!

i'm using groceryCRUD with postgresql and it works fine for me but if i search something with the exact same character as the word i have to search, it works(key sensitive search). if i perform a key insensitive search it doesn't work. i tried to replace LIKE with ILIKE , which in postgresql stand for key insensitive search, and it works with some fields (like name and surname) but it throws error 500 for other fields (like country and city).

I replaced LIKE in /DB_query_builder.php.

the error looks like this:

 

jquery-1.11.1.min.js:4 POST http://127.0.0.1/my_.../ajax_list_info 500 (Internal Server Error)

 

Can somebody help me?

 

Thanks a lot







Also tagged with one or more of these keywords: grocery crud, kei insensitive, search function, bugs

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users