wanaka
|
| Posted: 04/27/2003, 10:33 PM |
|
I want to have case insensitve search so instead of select * from person where lastname= s_keyword
I want to change to select * from person where lastname ilike s_keyword
I am using ccs which part of the code should I cahnge
|
|
|
 |
RG
|
| Posted: 04/27/2003, 10:41 PM |
|
|
|
|
|
RG
|
| Posted: 04/27/2003, 10:41 PM |
|
Go to the property 'Data Source' of your grid. There you should see your 'Where' clause. You can add or change your 'Where' clause:
Field:
Name: last_name
Type: Text
Condition:
contains (like '%...%')
Parameter Source:
Name: s_keyword
Type: URL
|
|
|
|
wanaka
|
| Posted: 04/27/2003, 11:37 PM |
|
Yes I know but you still cannot specify ILIKE for postgres database case insensitive search
|
|
|
|
RG
|
| Posted: 04/28/2003, 12:36 AM |
|
Sorry for that. Would it work if you use SQL instead of Table for your Data Source Type and write your own SQL query?
|
|
|
|
