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?
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
----------------------------------------------------------------
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------
