Hi,

I've got a problem with a query

The followings return the right results sets
SELECT * FROM nt:base WHERE keywords like '%keyword%' 
SELECT * FROM nt:base WHERE jcr:path like '/Path/To/My/Folder/%' 

But the following return an empty results set.
SELECT * FROM nt:base WHERE keywords like '%keyword%' or  jcr:path like 
'/Path/To/My/Folder/%' 

Could someone help with that? Is there is something wrong with my "or" 
statement?

Thanks you very much

Stéphane Gauthier



************************************************************************************
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://documentation.magnolia.info/docs/en/editor/stayupdated.html
----------------------------------------------------------------

Reply via email to