jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "gary long" <gary.l...@gmx.fr>
Subject problem with SQL query and full text search
Date Thu, 18 Mar 2010 17:12:47 GMT
Hi Hi :) 

I try to write a query that searches for a text in the properties of a certain type of node
in my repository. I thought it could be possible to write something like : 

SELECT * FROM mnt:resource WHERE contains((jcr:name, jcr:content), "my text"); 

But it doesn't work :( 

So, is there a mean to specify multiple columns in a contains() or is it possible to write
multiple contains in a single SQL request? 

Thank you :) 

Regards, 
Gary

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message