Hi Boris
Thanks for the explanation.
One question still remains:
Do I interpret your post correctly if I read:
substituting "like" by "contains" in an sql search statement through
info.magnolia.cms.core.search.QueryManager does not deliver case
insensitive results (as opposed to Sameers mail from august 31)?
if so I can start hacking workarounds if not it would be obvious that
I'm doing something wrong and hence I would appreciate very much
pointers where I can find out more about the proper syntax/usage.
THX!
Thomas
(aka HansFreddi)
On 05.09.2006, at 15:48, Boris Kraft wrote:
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
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------
