The classical database solution to that problem is to store whatever
you want searchable in a separate field and lowercase its input, then
lowercase the search string.
Example:
Your form input:
Name: Hansrudi
Store this in
SearchName: hansrudi
Your Search Input:
HansRudi
You search for lowercase ("HansRudi") in SearchName.
Cheers
Boris
On 04.09.2006, at 16:15, Thomas Martin wrote:
Salut Stéphan,
Thanks for the input - I tried that too but again: empty results.
Thomas
On 04.09.2006, at 15:48, Gauthier, Stephane (CH Temp) wrote:
Hi Thomas,
I didn't get the time to test it but I would have try something
like that:
sql += "text CONTAINS '"+querryParts[i]+"' or lowertitle CONTAINS
'"+querryParts[i]+"' or lead CONTAINS '"+querryParts[i]+"'";
...Without the percent...
Does it make sense?
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------
