Discussion:
Searchword with a . in it
(too old to reply)
Søren Reinke
2006-06-07 11:04:16 UTC
Permalink
Hi there

I have a problem with using Indexing Server,

When i search for 'adsl.dk' i find a lot of pages containg 'dk' but without
'adsl.' in front.

How do i tell the indexing server not to do that and only give me result
with 'adsl.dk' ?

This is the query:
query = "SELECT DOCTITLE, RANK FROM SCOPE() where freetext(contents,'" +
searchWord + "') order by RANK DESC"

Best regards

Søren Reinke
Hilary Cotter
2006-06-07 23:22:08 UTC
Permalink
use contains, ie

query = "SELECT DOCTITLE, RANK FROM SCOPE() where CONTAINS(contents,'" +
searchWord + "') order by RANK DESC"
--
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
Post by Søren Reinke
Hi there
I have a problem with using Indexing Server,
When i search for 'adsl.dk' i find a lot of pages containg 'dk' but
without 'adsl.' in front.
How do i tell the indexing server not to do that and only give me result
with 'adsl.dk' ?
query = "SELECT DOCTITLE, RANK FROM SCOPE() where freetext(contents,'" +
searchWord + "') order by RANK DESC"
Best regards
Søren Reinke
Søren Reinke
2006-06-09 09:07:50 UTC
Permalink
Post by Hilary Cotter
use contains, ie
query = "SELECT DOCTITLE, RANK FROM SCOPE() where CONTAINS(contents,'" +
searchWord + "') order by RANK DESC"
Thanks a lot :) now it works :)

/Søren

Loading...