MMBase

search LIKE in editwizards not case-insenstitive

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Minor Minor
  • Resolution: Fixed
  • Affects Version/s: 1.6.1
  • Fix Version/s: 1.6.4
  • Component/s: Editwizards
  • Description:
    Hide
    original bugid: #6040
    You can perform a search in the editwzards by specifying searchfields/searchvalue/searchtype parameters on the list.jsp.
    If searchtype ='like' (the default), the search is not case-insensitive if the database does not perform so on its own.
    The query created now follows the syntax as used in other places:

     lower(searchfield) LIKE '%searchvalue%'

    where 'searchvalue' is converted to lowercase.
    Show
    original bugid: #6040 You can perform a search in the editwzards by specifying searchfields/searchvalue/searchtype parameters on the list.jsp. If searchtype ='like' (the default), the search is not case-insensitive if the database does not perform so on its own. The query created now follows the syntax as used in other places:  lower(searchfield) LIKE '%searchvalue%' where 'searchvalue' is converted to lowercase.

Activity

Hide
Pierre van Rooden added a comment - 2003-05-02 11:09
search LIKE in editwizards not case-insenstitive
Tou can perform a search in the editwzards by specifying searchfields/searchvalue/searchtype parameters on the list.jsp.
If searchtype ='like' (the default), the search is not case-insensitive if the database does not perform so on its own.
The query craeted should follow the syntax as used in other places:

 lower(searchfield) LIKE '%searchvalue%'

where 'searchvalue' is converted to lowercase.
Show
Pierre van Rooden added a comment - 2003-05-02 11:09 search LIKE in editwizards not case-insenstitive Tou can perform a search in the editwzards by specifying searchfields/searchvalue/searchtype parameters on the list.jsp. If searchtype ='like' (the default), the search is not case-insensitive if the database does not perform so on its own. The query craeted should follow the syntax as used in other places:  lower(searchfield) LIKE '%searchvalue%' where 'searchvalue' is converted to lowercase.

People

Dates

  • Created:
    2003-05-02 11:15
    Updated:
    2006-11-24 12:39
    Resolved:
    2006-11-24 12:39