Re: FT Search with nois words

From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 10/21/04 

Date: Thu, 21 Oct 2004 05:23:31 -0400

yes, they will no longer be searched on. Your best bet is to filter them out
at the client. 

-- 
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Marius" <marius@kanniets.nl> wrote in message
news:65032a84.0410200111.64e78be9@posting.google.com...
> But if I empty this file it will no longer ignore the noise words
> (right?).
>
> What I want is that the words will be ignored but the query will still
> continue searching the database.
> Here is the query I use to search:
>
> --Begin
> SELECT Total.TopicID,
>        f.AuthorizationItemID,
>        ft.TopicTitle,
>        ft.TopicStatus,
>        (SELECT MAX(PostDate) FROM ForumPost WHERE TopicID =
> Total.TopicID) AS LastPost,
>        (SELECT COUNT(*) - 1 FROM ForumPost WHERE TopicID =
> Total.TopicID) AS NumberOfReplies,
>        (SELECT UserFirstName + ' ' + UserLastName FROM Users WHERE
> UserID = (SELECT UserID FROM ForumPost WHERE TopicID = Total.TopicID
> AND PostDate = (SELECT MIN(PostDate) FROM ForumPost WHERE TopicID =
> Total.TopicID))) AS Poster,
>        f.ForumAfk,
>        f.ForumName,
>        f.ForumID,
>        fc.CategoryName,
>        SUM(Total.Score) AS Score
> FROM
> (
> SELECT fp.TopicID,
>        SUM(A.RANK) AS Score
>
> FROM   CONTAINSTABLE (ForumPost, PostMessage, @strSearchString) A
> JOIN   ForumPost fp ON A.[Key] = fp.PostID
>
> GROUP BY fp.TopicID
>
>
> UNION ALL
>
>
> SELECT B.[Key] AS TopicID,
>        B.RANK * 3 AS Score
>
> FROM   CONTAINSTABLE (ForumTopic, TopicTitle, @strSearchString) B
> ) AS Total
> JOIN ForumTopic ft ON Total.TopicID = ft.TopicID
> JOIN ForumCategory fc ON ft.CategoryID = fc.CategoryID
> JOIN Forum f ON fc.ForumID = f.ForumID
>
> GROUP BY Total.TopicID, f.AuthorizationItemID, ft.TopicTitle,
> ft.TopicStatus, ft.CategoryID, f.ForumAfk, f.ForumName, f.ForumID,
> fc.CategoryName
> ORDER BY Total.Score DESC
> --End
>
> The query it self works perfectly as far is I tested. But a
> searchstring like 'test AND is' fails. Looking for a string like
> '"test is"' does work but then it wil look for that exact string and
> that's not the answer i'm looking for.
>
> A option is ofcourse to remove the noise words from the string in my
> code so they never end up in the store procedure. But I realy don't
> like that solution so I hope there is an other way.
>
> Marius
>
> "Kevin Lewis" <lewis.kevin@myfloridahouse.com> wrote in message
news:<eoyE5eitEHA.4044@TK2MSFTNGP09.phx.gbl>...
> > SQL Server has a config file that specifies all the noise words it
ignores
> > in full text searches.  It is located here:
> >
> > Program Files\Microsoft SQL
Server\MSSQL\FTDATA\SQLServer\Config\noise.eng
> >
> > I'm not sure of the specifics on how you get SQL Server to recognize an
> > update to this file.
> >
> > "Marius" <marius@kanniets.nl> wrote in message
> > news:65032a84.0410190111.196b8638@posting.google.com...
> > > Hello,
> > >
> > > Is there a way to make it possible to search for the following
> > > searchstring with containstable?
> > >
> > > "test AND is"
> > >
> > > what i mean is that it will ignore the word "is" but will continu
> > > searching for "test"
> > >
> > > thnx in advance,
> > >
> > > Marius

Relevant Pages

  • Re: SQL query fails
    ... but the second operator in the string has 3 ... that is acceptable to Oracle, SQL Server, and Access. ... >> I have a query that works in Oracle and SQL Server, ...
    (microsoft.public.access.queries)
  • Re: Ignored words problem
    ... Looking for a book on SQL Server replication? ... >> avoid it either via removing noise words from the specific language ... >> prior to submitting the user's query input to SQL Server. ... >> 9952 This is sample text data for Scootney Books, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SQL Server dataset read from database A and write to database B
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... private bool ImportXML(string docIn, ref string ErrorMsg) ... SqlCommand query = new SqlCommand ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Word 2003 MailMerge with SQL Server 2000 problem
    ... Okay, I switched the way I was connecting, and started using a DSN ... If I could either create a DSN-less connection string for Mail Merge, ... Personally I wouldn't use the 1=1 workaround on the grounds that the query ... SQL Server does but I once did this with Oracle to get around some problem ...
    (microsoft.public.word.mailmerge.fields)
  • RE: Executing A Stored Procedure From An Access Query
    ... How does Access know which SQL Server database to execute the stored ... > If to follow Rick steps, after assigning a string to the Pass-Through query ... >> Is there a way to call a SQL Server Stored Procedure as the RecordSource for ...
    (microsoft.public.access.queries)