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? Stéphane Gauthier Webmaster * IT Lloyds TSB International Private Banking -----Original Message----- From: Thomas Martin [mailto:[EMAIL PROTECTED] Sent: Monday, September 04, 2006 3:42 PM To: [email protected] Subject: Re: [magnolia-user] not realy suitable for camelcase stuff :) I tried sameers hint to use CONTAINS but alas had no luck. Once I change my original code: [...] sql += "text LIKE '%"+querryParts[i]+"%' or lowertitle LIKE '%"+querryParts[i]+"%' or lead LIKE '%"+querryParts[i]+"%'"; [...] to [...] sql += "text CONTAINS '%"+querryParts[i]+"%' or lowertitle CONTAINS '%"+querryParts[i]+"%' or lead CONTAINS '%"+querryParts[i]+"%'"; [...] results are empty. Stéphane: did it work for you? I also found some threads regarding this subject http://www.mail-archive.com/[email protected]/ msg03512.html http://comments.gmane.org/gmane.comp.apache.jackrabbit.devel/3062 that obviously point in the same direction - nevertheless it seems I'm missing something. Can someone shed some light on this? Thanks a lot. Thomas On 02.09.2006, at 15:26, Boris Kraft wrote: > skip the first letter ;-) > - Boris > > On 31.08.2006, at 15:54, Gauthier, Stephane (CH Temp) wrote: > >> Hi Magnolians, >> >> Does someone knows how to make JCR-SQL searchs that are not case >> sensitive? >> Ex. Keywords like '%whatever%' matches only 'whatever' and not >> 'Whatever' >> Could be something in a configuration file? >> >> Many thanks for your help. >> >> Stéphane Gauthier >> Webmaster * IT >> Lloyds TSB International Private Banking >> >> >> ********************************************************************* >> *************** >> This email and any files transmitted with it are confidential and >> intended solely for the use of the individual or entity to whom >> they are addressed. >> If you have received this email in error, please notify the system >> manager ([EMAIL PROTECTED]) and delete the message with any >> attached files from your system. >> The confidentiality and integrity of this message cannot be >> guaranteed on the Internet and the sender does not accept >> liability for its content. >> >> ********************************************************************* >> ************** >> >> >> ---------------------------------------------------------------- >> for list details see >> http://www.magnolia.info/en/magnolia/developer.html >> ---------------------------------------------------------------- > > > ---------------------------------------------------------------- > for list details see > http://www.magnolia.info/en/magnolia/developer.html > ---------------------------------------------------------------- ---------------------------------------------------------------- for list details see http://www.magnolia.info/en/magnolia/developer.html ---------------------------------------------------------------- ************************************************************************************ This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify the system manager ([EMAIL PROTECTED]) and delete the message with any attached files from your system. The confidentiality and integrity of this message cannot be guaranteed on the Internet and the sender does not accept liability for its content. *********************************************************************************** ---------------------------------------------------------------- for list details see http://www.magnolia.info/en/magnolia/developer.html ----------------------------------------------------------------
