 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / August 2007Criterias with Full text search
I am trying to create a full text search which allows users to choose such things as "with this exact phrase" , "with all of these words" AND "Without these words" etc. I tried using freetexttable command to search through the columns which was fine but it did not exclude the words that was contained in the DO NOT criteria. It seems to be searching for all the text that is contained in the columns but it is avoiding to validate the DO NOT criteria? Help would be appreciated on this one cause I can't get it going. Thank you in Advance LeeRoy SELECT * From tblcontacts INNER JOIN (SELECT DISTINCT TOP 100 c.id AS contact_id, k.rank FROM contacts as c INNER JOIN freetextTABLE (tblcontacts, *, '"Head of Department" AND (Department AND Economics) AND NOT (university)') AS k ON ID = k.[key] ORDER BY k.rank DESC ) AS rankedIDs ON contacts.id = rankedIDs.contact_id Hello Pascal, You have to use containstable for that Simon Sabin SQL Server MVP http://sqlblogcasts.com/blogs/simons > I am trying to create a full text search which allows users to choose > such things as "with this exact phrase" , "with all of these words" [quoted text clipped - 19 lines] > rankedIDs ON > contacts.id = rankedIDs.contact_i Good morning Simon and thanks for you help. The problem with Constainstable with our SQL statement, is that it applies the 3 criterias on a per column basis. We need the 3 criterias to be evaluated to all the columns of the table at the same time as if they were all concatenated together like one big column and not evaluated on a per column to column basis. Maybe we are not aware that freetext, constains or containstable works on a per column to column basis? LeeRoy > Hello Pascal, > [quoted text clipped - 27 lines] > > rankedIDs ON > > contacts.id = rankedIDs.contact_id |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.