Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Fulltext Search within Results


Fulltext Search within Results

Author
Message
fmshafiq
fmshafiq
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
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
antonio.collins
antonio.collins
SSChasing Mays
SSChasing Mays (600 reputation)SSChasing Mays (600 reputation)SSChasing Mays (600 reputation)SSChasing Mays (600 reputation)SSChasing Mays (600 reputation)SSChasing Mays (600 reputation)SSChasing Mays (600 reputation)SSChasing Mays (600 reputation)

Group: General Forum Members
Points: 600 Visits: 921
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")')
fmshafiq
fmshafiq
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 8
Unfortunately its not working in my scenario
fmshafiq
fmshafiq
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search