Aaron
|
| Posted: 08/06/2002, 11:10 AM |
|
I am using CodeCharge JSP w/ Templates. I have set up my search (on the same problem as the grid) to use like '...%' on my builder field. This should allow me to search for k and get all builders starting with k, how ever this is not how it is acting. It won't allow me to use k* to do this same search either. I want to be able to search using wildcards. Currently in order to find the records I need I have to enter the exactly correct character string for the record. I really need a way to use wildcards.
thanks for your help,
Sorry for the repost, but I realized that my previous subject was confusing
|
|
|
 |
Ron
|
| Posted: 08/07/2002, 6:23 AM |
|
Aaron,
what you can do is to build custom Where clause on the fly depending on the entered search parameters.
You let users enter words like
*tom
tom*
*tom*
Then catch and parse the passed value and use operator depending on found "*". E.g. in case "*" is the first character in the string use
like '%passed_param_value'
etc.
|
|
|
|
|
