Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

search sql syntax freetext question AND works OR does not work

1 view
Skip to first unread message

cindy

unread,
Dec 7, 2009, 3:10:02 PM12/7/09
to
I am using sql syntax to execute a search query for a WSS 3.0 with Search
Server Express 2008 site

The AND syntax does return the correct number of results (9)
The OR syntax returns the same number it should be (26)

What am I doing wrong with the OR syntax


And queryText
"select url,Filename, ProductXRVL,ComponentXRVL,LibraryDocType,RevisedDate,
Abstract, Path, Rank from scope() WHERE \"scope\"='XR VL Library' AND
(FREETEXT(DefaultProperties,'+tube +beam')) "

OR queryText
"select url,Filename, ProductXRVL,ComponentXRVL,LibraryDocType,RevisedDate,
Abstract, Path, Rank from scope() WHERE \"scope\"='XR VL Library' AND
(FREETEXT(DefaultProperties,'tube beam')) "

cindy

0 new messages