Full text index not populating correctly

Hi
I have a table with 4 columns which are full-text indexed. I have noticed
that certain words are not being indexed and therefore not returned in
searches.
I have also noticed that the position on the word in the column effects
whether it is indexed.
For example:
I need to search a column called "Subtitle" which contains information on
product model numbers. If i search for "KF18W420GB" on a column that
contains "KF18W420GB stainless steel" then nothing is returned. If i change
the value in the database to "KF18W420GB" and repopulate the index then the
search works. Similarly, if i change the value in the database to "another
word KF18W420GB stainless steel" the search also works.
Does anyone know why this is? I am using SQL Server 7 on NT 4 - i am
guessing this is probably the problem and i am attempting to upgrade.
Thanks in advance.
Dan
Dan,
It would depend upon the OS platform wordbreaker, in this case the NT4.0
infosoft.dll. It also depends upon the exact SQL Server 7.0 FTS query
(contains vs. freetext) that you are using. Could you post the exact
CONTAINS* or FREETEXT* FTS query you are using as well as a sample of the
exact text you are expecting to return.
FYI, as you're using NT4.0, you can easily move in the Win2K version of
infosoft.dll as a test. If you want to do this, I have the exact methods on
how to do this.
Regards,
John
"Dan" <dan@.nospamplan9.co.uk> wrote in message
news:O4fDi9amEHA.3372@.TK2MSFTNGP15.phx.gbl...
> Hi
> I have a table with 4 columns which are full-text indexed. I have noticed
> that certain words are not being indexed and therefore not returned in
> searches.
> I have also noticed that the position on the word in the column effects
> whether it is indexed.
> For example:
> I need to search a column called "Subtitle" which contains information on
> product model numbers. If i search for "KF18W420GB" on a column that
> contains "KF18W420GB stainless steel" then nothing is returned. If i
change
> the value in the database to "KF18W420GB" and repopulate the index then
the
> search works. Similarly, if i change the value in the database to "another
> word KF18W420GB stainless steel" the search also works.
> Does anyone know why this is? I am using SQL Server 7 on NT 4 - i am
> guessing this is probably the problem and i am attempting to upgrade.
> Thanks in advance.
> Dan
>
|||Hi
i have tried using CONTAINSTABLE also but the result is the same as the
query below:
SELECT
KEY_TBL.Rank,
FT_TBL.LinkText,
FT_TBL.PageId,
FT_TBL.template
FROM (tblPageContent AS FT_TBL
INNER JOIN FREETEXTTABLE(tblPageContent,*,'KF18W420GB') AS KEY_TBL
ON FT_TBL.PageID = KEY_TBL.[KEY])
WHERE FT_TBL.Search !=0 ORDER BY KEY_TBL.RANK DESC
Select @.@.version:
Microsoft SQL Server 7.00 - 7.00.1063 (Intel X86) Apr 9 2002 14:18:16
Copyright (c) 1988-2002 Microsoft Corporation Standard Edition on Windows
NT 4.0 (Build 1381: Service Pack 6)
Select @.@.language:
us_english
"John Kane" <jt-kane@.comcast.net> wrote in message
news:e3EU%231bmEHA.3356@.TK2MSFTNGP14.phx.gbl...
> Dan,
> It would depend upon the OS platform wordbreaker, in this case the NT4.0
> infosoft.dll. It also depends upon the exact SQL Server 7.0 FTS query
> (contains vs. freetext) that you are using. Could you post the exact
> CONTAINS* or FREETEXT* FTS query you are using as well as a sample of the
> exact text you are expecting to return.
> FYI, as you're using NT4.0, you can easily move in the Win2K version of
> infosoft.dll as a test. If you want to do this, I have the exact methods
> on
> how to do this.
> Regards,
> John
>
> "Dan" <dan@.nospamplan9.co.uk> wrote in message
> news:O4fDi9amEHA.3372@.TK2MSFTNGP15.phx.gbl...
> change
> the
>
|||Dan,
If you re-write the query and remove the where clause (WHERE FT_TBL.Search
!=0)
SELECT KEY_TBL.Rank, FT_TBL.LinkText, FT_TBL.PageId, FT_TBL.template
FROM tblPageContent AS FT_TBL
INNER JOIN FREETEXTTABLE(tblPageContent,*,'KF18W420GB') AS KEY_TBL
ON FT_TBL.PageID = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK DESC
does it return any &/or expectant results? If not, then as this is SQL 7.0
on NT4.0, this may be a NT4.0 wordbreaking issue, and unfortunately, I don't
have an NT4.0 installation to test the NT4.0 version of infosoft.dll. In the
row that contains the above search string 'KF18W420GB' is there any other
characters &/or punctuation that is in contact or touching the search
string?
Thanks,
John
"Dan" <dan@.nospamplan9.co.uk> wrote in message
news:eqzVCZemEHA.2616@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Hi
> i have tried using CONTAINSTABLE also but the result is the same as the
> query below:
> SELECT
> KEY_TBL.Rank,
> FT_TBL.LinkText,
> FT_TBL.PageId,
> FT_TBL.template
> FROM (tblPageContent AS FT_TBL
> INNER JOIN FREETEXTTABLE(tblPageContent,*,'KF18W420GB') AS KEY_TBL
> ON FT_TBL.PageID = KEY_TBL.[KEY])
> WHERE FT_TBL.Search !=0 ORDER BY KEY_TBL.RANK DESC
> Select @.@.version:
> Microsoft SQL Server 7.00 - 7.00.1063 (Intel X86) Apr 9 2002 14:18:16
> Copyright (c) 1988-2002 Microsoft Corporation Standard Edition on Windows
> NT 4.0 (Build 1381: Service Pack 6)
> Select @.@.language:
> us_english
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:e3EU%231bmEHA.3356@.TK2MSFTNGP14.phx.gbl...
the[vbcol=seagreen]
noticed[vbcol=seagreen]
on
>
|||No, that doesn't make a difference. There is no other words/characters other
than those specified.
I will endevour to upgrade the server.
Thanks
Dan
"John Kane" <jt-kane@.comcast.net> wrote in message
news:uIexBlgmEHA.512@.TK2MSFTNGP10.phx.gbl...
> Dan,
> If you re-write the query and remove the where clause (WHERE FT_TBL.Search
> !=0)
> SELECT KEY_TBL.Rank, FT_TBL.LinkText, FT_TBL.PageId, FT_TBL.template
> FROM tblPageContent AS FT_TBL
> INNER JOIN FREETEXTTABLE(tblPageContent,*,'KF18W420GB') AS KEY_TBL
> ON FT_TBL.PageID = KEY_TBL.[KEY]
> ORDER BY KEY_TBL.RANK DESC
> does it return any &/or expectant results? If not, then as this is SQL 7.0
> on NT4.0, this may be a NT4.0 wordbreaking issue, and unfortunately, I
> don't
> have an NT4.0 installation to test the NT4.0 version of infosoft.dll. In
> the
> row that contains the above search string 'KF18W420GB' is there any other
> characters &/or punctuation that is in contact or touching the search
> string?
> Thanks,
> John
>
>
> "Dan" <dan@.nospamplan9.co.uk> wrote in message
> news:eqzVCZemEHA.2616@.tk2msftngp13.phx.gbl...
> the
> noticed
> on
>