Re: Error on Full Text search

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: John Martin (john.martin_at_spammersuntied.com)
Date: 03/12/04 

Date: Fri, 12 Mar 2004 16:24:22 -0500

Fixed!

Thank you very much!

John

"John Kane" <jt-kane@comcast.net> wrote in message
news:O2He9O7BEHA.1128@TK2MSFTNGP11.phx.gbl...
> Yep, I guess we can add a 4th solution...
> -- FREETEXTTABLE vs. CONTAINSTABLE and Error 7619 - A clause of the query
> contained only ignored words
>
> select * from pub_info as A, containstable(pub_info, *, ' "how" and "do"
and
> "I" and "add" and "a" and "listing" ') as AST
> where (pub_id = '0736') and AST.[KEY] = A.pub_id order by RANK desc
> /* -- returns:
> Server: Msg 7619, Level 16, State 1, Line 1
> Execution of a full-text operation failed. A clause of the query contained
> only ignored words.
> */
>
> select * from pub_info as A, freetexttable(pub_info, *, ' "how" and "do"
and
> "I" and "add" and "a" and "listing" ') as AST
> where (pub_id = '0736') and AST.[KEY] = A.pub_id order by RANK desc
> /* -- returns:
> pub_id logo pr_info
> KEY RANK
> ------ -------------------------------------------------- ---------------- 

--
> -------------------------------- ---- ----------- 
>
> (0 row(s) affected)
> */
>
> Regards,
> John
>
>
>
> "Hilary Cotter" <hilaryk@att.net> wrote in message
> news:#zVc#46BEHA.712@tk2msftngp13.phx.gbl...
> > or you could do a freetext search.
> >
> > "John Kane" <jt-kane@comcast.net> wrote in message
> > news:uXWVba6BEHA.3284@TK2MSFTNGP09.phx.gbl...
> > > Jon,
> > > Yep, I can help. This is a very common issue with effectively using
SQL
> > > Full-text Search. It also shows up as "Server: Msg 7619:> Execution of
a
> > > full-text operation failed. A clause of the query contained only
ignored
> > > words". There are several solutions that you can use:
> > >
> > > 1. Remove all or most noise words from the language-specific
(noise.enu
> =
> > > US_English, noise.eng = UK_English) noise word under
> > > \FTDATA\SQLServer\Config\noise.* and then re-run a Full Population.
> Note,
> > > you will need to stop the MSSearch service in order to save the
changes
> to
> > > these files.
> > >
> > > 2. see KB article 246800 (Q246800) "INF: Correctly Parsing Quotation
> Marks
> > > in FTS Queries" at
> > > http://support.microsoft.com//default.aspx?scid=kb;EN-US;246800
> > >
> > > 3. Search this newsgroup for  - SearchPage.htm - a client-side
> > > implementation  from Hilary Cotter. If you cannot find the code as
both
> > > Hilary and I have posted it here, let me know and I can re-post it.
> > >
> > > Regards,
> > > John
> > >
> > >
> > >
> > >
> > > "John Martin" <john.martin@spammersuntied.com> wrote in message
> > > news:%G14c.59319$Ri6.13763@lakeread04...
> > > > Hello,
> > > >
> > > > I have run into a brick wall here.   I hope someone can help.
> > > >
> > > > When running a search I get this error:
> > > >
> > > > Application Error: [Microsoft][ODBC SQL Server Driver][SQL Server]A
> > clause
> > > > of the query contained only ignored words.
> > > >
> > > > I researched somewhat and found that it could be that the noise word
> > list
> > > > noise.eng was causing this.
> > > >
> > > > I edited the list, rebuilt and repopulated the FT Catalog.....
> > > >
> > > > Is there something I'm missing here?
> > > >
> > > > Here is a search that generates the error:
> > > >
> > > > select **** from ARTICLES as A, containstable(ARTICLES, *, ' "how"
and
> > > "do"
> > > > and "I" and "add" and "a" and "listing" ') as AST
> > > > where (LANGUAGE_REF= 1) and AST.[KEY] = A.ARTICLE_ID order by RANK
> desc
> > > >
> > > > Thanks for all help,
> > > >
> > > > Jon
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Sentences without any subject
    ... John> course is irrelevant)? ... Why should word order be irrelevant? ... though it has prepositions and V2 in main clauses), as was Old English. ... even when the modifier is a clause. ...
    (sci.lang)
  • Re: Is this sentense correct?
    ... "The only one who were present were John and myself." ... I will give it to you" is clearly missing a verb from the first clause. ... Like many native English speakers, when it comes to these rather messy futures in English I can easily say what "feels" right, but find it very hard to explain why. ...
    (alt.usage.english)
  • Re: Insert with Multiple SubQueries - Possible?
    ... "John Dinning" wrote in message ... > statement will insert only one record in the CourseStudent Table. ... > I originally had a VALUES clause but was advised that SubQueries cannot be ... >> <Access MVP> ...
    (microsoft.public.access.queries)
  • Re: NOT Like Syntax
    ... Thanks John. ... makes sense and thanks for the tip on the free fortmat text. ... the criterion on toll_plan_description should be in a separate WHERE clause; ... LIKE honors wildcards, but IN does not! ...
    (microsoft.public.access.queries)
  • Re: Resetting Links to Delimited Text Files
    ... >> necessary SQL statements for whatever queries are required. ... >> the FROM clause, with a hash substituting for the normal dot. ... John Nurick ...
    (microsoft.public.access.externaldata)