[#MMB-179] search LIKE in editwizards not case-insenstitive - MMBase

Details

Type: Bug
Status: Resolved
Priority: 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

Ascending order - Click to sort in descending order

Hide

Permalink

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

Assignee:

MMBase Project Leader

Reporter:

Pierre van Rooden
Votes:

0

Watchers:

0

Dates

Created:

2003-05-02 11:15

Updated:

2006-11-24 12:39

Resolved:

2006-11-24 12:39