Re: freetexttable bug
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Wed, 17 Oct 2007 22:37:20 -0400
No, unfortunately not.
--
RelevantNoise.com - dedicated to mining blogs for business intelligence.
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
"Baldwin" <ibaldwinjr@xxxxxxxxx> wrote in message
news:1192652305.771160.110030@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Oct 17, 7:27 am, "Hilary Cotter" <hilary.cot...@xxxxxxxxx> wrote:
duh silly me. You need to remove AT from your noise word list and then
rebuild your catalog.
--
RelevantNoise.com - dedicated to mining blogs for business intelligence.
Looking for a SQL Server replication
book?http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL
FTShttp://www.indexserverfaq.com"Hilary Cotter" <hilary.cot...@xxxxxxxxx>
wrote in message
news:enGf5gGEIHA.4772@xxxxxxxxxxxxxxxxxxxxxxx
I've repro'd this. It could be by design, I'll raise it internally and
see
if it is a bug.
--
RelevantNoise.com - dedicated to mining blogs for business
intelligence.
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
"Baldwin" <ibaldwi...@xxxxxxxxx> wrote in message
news:1192202141.265102.33850@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,
We've been using the catalog as part of our search engine for a year
now. We use freetexttable to search for keywords and it is fine until
now. For some reason the 'freetexttable' is inconsistent.
I tried this query and I got a lot of rows.
select * from tb_catalog
where content like '%AT&T%'
When I try this, I dont get anything.
select * from freetexttable(tb_catalog, *, 'AT&T')
But when I try this, I got rows.
select * from freetexttable(tb_catalog, *, 'SB&C')
So I thought it is just an ampersand issue but it worked in the last
query.
Any thoughts are really appreciated.
Great Thanks,
Baldwin
MISICompany- Hide quoted text -
- Show quoted text -
Thanks for the reply. But I dont think I want to do that. If I removed
the "AT" from the list of noise words, I can now search for "AT".
The other thing is, is the "&" was converted to space or something
that the search engine now is looking for "AT" and "T" but both are
considered as noise words thus not returning anything as oppose to
considering the AT&T as one word. take note that there is no space
between letters - "AT&T". is there a way we can use an escape
character for "&" so the search engine will consider AT&T as one word?
thanks really for the help.
Baldwin
.
- References:
- freetexttable bug
- From: Baldwin
- Re: freetexttable bug
- From: Hilary Cotter
- Re: freetexttable bug
- From: Hilary Cotter
- Re: freetexttable bug
- From: Baldwin
- freetexttable bug
- Prev by Date: Re: freetexttable bug
- Next by Date: SQL Server 2005 with advanced services and full text search
- Previous by thread: Re: freetexttable bug
- Next by thread: SQL Server 2005 with advanced services and full text search
- Index(es):
Relevant Pages
|
