all groups > sql server full text search > september 2005 >
You're in the

sql server full text search

group:

Thought I had a good idea about searching for "C programmers"


Thought I had a good idea about searching for "C programmers" Kyle Jedrusiak
9/23/2005 9:53:34 AM
sql server full text search:
I went and edited all three instances of the noise.eng files on the server.

I forced the server todo a full population of the indexes.

The problem is, of course, it finds every instance of the letter "C", not
only when it occurs by itself, but even when it occurs inside a word.

Help!

Kyle!

Re: Thought I had a good idea about searching for "C programmers" Hilary Cotter
9/23/2005 10:49:17 AM
This doesn't sound right. Could you post your query?

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

Re: Thought I had a good idea about searching for "C programmers" Kyle Jedrusiak
9/23/2005 10:58:30 AM
I have to put something past the other programmer.

It may be something in his code that isn't correct.

Kyle!

[quoted text, click to view]

Re: Thought I had a good idea about searching for "C programmers" Daniel Crichton
9/26/2005 2:55:16 PM
If he's using "C*" that would explain all words starting with C, but FTS
can't pick up "words" inside of indexed words, it can only do a "starting
with" style match.

Dan

Kyle wrote on Fri, 23 Sep 2005 10:58:30 -0400:

[quoted text, click to view]

Re: Thought I had a good idea about searching for "C programmers" Kyle Jedrusiak
9/26/2005 3:29:39 PM
It a problem inside the app.

Once we have a document that we want to look at (via the FT search)...he
shows the document he highlights every instance of the substring in the
document, not every instance of the word.

So if we search for 'c' the FT search works correctly...he highlights every
letter 'c' in the document viewer.

Kyle!

[quoted text, click to view]

AddThis Social Bookmark Button