Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Fulltext Search within Results Expand / Collapse
Author
Message
Posted Wednesday, May 28, 2008 10:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 8, 2010 1:45 AM
Points: 3, Visits: 8
I am new in SQL SERVER, working on SQL SERVER 2005 I have a requirement to do nth level fulltext search into result set of a fulltext query.

What is the requirement?

I have a textbox to get search keyword and a check box of SEARCH WITHIN RESULT or NEW SEARCH and a button of search.

User first search for a new query for KEYWORD1 and got a result set, then he check the SEARCH WITHIN RESULT and enter KEYWORD2 into textbox, he want to search into the result set of KEYWORD1 and get the second result set for KEYWORD2 that is actually a sub set of first result set, he want another SEARCH WITHIN RESULT for KEYWORD3 that would be the third result set and sub set of second result set of KEYWORD2. It would run until user has not enough record to search.

My Query

I write a query for that purpose but it just get result set for second level, for third and forth level it fails.


SELECT FT_MashupMetaInfo.*,
KEY_TBL.RANK
FROM MashupMetaInfo AS FT_MashupMetaInfo
INNER JOIN FREETEXTTABLE(MashupMetaInfo, *,
'FORMSOF (INFLECTIONAL,"New Mashup" )') AS KEY_TBL
ON FT_MashupMetaInfo.ID = KEY_TBL.[KEY]
WHERE Contains(CategoryName,'ARTS')
AND Contains(Tags,'"Mashup"')
AND freetext((Title,Description),'FORMSOF (INFLECTIONAL, "adi great" OR "Video")')
ORDER BY KEY_TBL.RANK DESC

Help Me

Can some Experts Help me
Post #507828
Posted Wednesday, May 28, 2008 8:04 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 12:06 PM
Points: 438, Visits: 907
you just need to append the new keyword(s) to the existing criteria.

first pass:
AND freetext((Title,Description),'FORMSOF (INFLECTIONAL, "adi great" OR "Video")')
next pass:
AND freetext((Title,Description),'FORMSOF (INFLECTIONAL, "adi great" OR "Video" OR "night life")')

Post #508122
Posted Monday, June 2, 2008 4:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 8, 2010 1:45 AM
Points: 3, Visits: 8
Unfortunately its not working in my scenario
Post #509737
Posted Monday, June 2, 2008 4:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 8, 2010 1:45 AM
Points: 3, Visits: 8
either i writing this

AND freetext((Title,Description),'FORMSOF (INFLECTIONAL, "adi great" OR "Video" OR "night life")')


or


AND freetext((Title,Description),'FORMSOF (INFLECTIONAL, "adi great" AND "Video" AND "night life")')

returns same result
Post #509739
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse