Ignore case
|
Posted: 09/15/2005, 12:58 PM |
|
I am using Oralce database which is case sensitive.
How do I ignore case for Searches. The Search fields generated by CodeCharge does not have any checkbox to ignore case of the search data entered.
|
|
|
peterr
Posts: 5971
|
Posted: 09/15/2005, 1:28 PM |
|
The search fields only accept search keywords from users. They do not do any searching. The data is then filtered by the grid.
You can enter any SQL that you want in your grid's data source. So you can use such SQL that brings up case insensitive results, for example using UPPER function. Or refer to Oracle database documentation to find out how to perform case insensitive searches. There are also many articles on the Internet about case sensitive/insensitive SQL queries, and you might want to Google for those.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
newbie
|
Posted: 09/15/2005, 1:36 PM |
|
Thanks buddy. This is what I wanted to confirm, that there is no "check box" or something to do this automagically. I will go ahead and modify the generated SQLs.
|
|
|
peterr
Posts: 5971
|
Posted: 09/15/2005, 1:36 PM |
|
BTW, here is an additional forum search that you can perform to find past discussions related to such searches: http://forums.codecharge.com/search.php?s_keyword=CaSe+...[]=29&s_period=
Note that it is case insensitive
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|