dear all,
I am searching within in properties indexes. There are two keywords "like"and
"propcontains". The "Like" keyword always gives the result for any property
including those which are not indexed. but propcontains gives result for those
which are indexed. Am I right?.
I have got a situation where i want to search for any property. If the
property is indexed then it should use "propcontains"(for faster result) ,
otherwise it should use "like". I am using the below syntax, is it rihgt or
does it degrade the performance, plz give me guideness on it.
"<D:where>" +
"<D:or>"+
"<S:propcontains><D:prop><D:author/></D:prop><D:literal>root*</D:literal></S:propcontains>"
+
"<D:like><D:prop><D:author/></D:prop><D:literal>root%</D:literal></D:like>" +
"</D:or>"+
"</D:where>" +
I want that if first ("propcontain") gives the result than second line
("like") should not execute.
Thankss..
---------------------------------
Here's a new way to find what you're looking for - Yahoo! Answers
Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it
NOW
