issues with exact phrase searching

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ocelot4401@gmail.com - 23 Oct 2007 18:19 GMT

I'm finding that using CONTAINS () and any word or phrase containing
an ' does not work. It seems to split the phrase up instead of doing
an EXACT MATCH search.

example: searching on "computer's technology"

the SQL looks like:
SELECT DocTitle, Filename, Vpath, Size, Write, Characterization, Rank
FROM SCOPE() WHERE CONTAINS ('"computer''s technology"') > 0

this returns files containing "computer" and/or "technology"
not the exact phrase.

I don't believe the issues is my syntax, cause the search works
properly when it's "computer technology", whose SQL looks like:
SELECT DocTitle, Filename, Vpath, Size, Write, Characterization, Rank
FROM SCOPE() WHERE CONTAINS ('"computer technology"') > 0 AND
(Filename LIKE '%_%_%_%.pdf')

Any help? sorry if this is commonly covered, I searched the group and
didn't seem to find anything recent that applied to my issue.
Thanks for your time.

Reply to this Message

Hilary Cotter - 24 Oct 2007 17:22 GMT

This is an indexing services question and an NT 4.0 Index Server 1 one at
that. To make your query Windows 200X Indexing Services 2.0 compliant you
must do this:

SELECT DocTitle, Filename, Vpath, Size, Write, Characterization, Rank
FROM SCOPE() WHERE CONTAINS ('"computer''s technology"')

Did you set allow enumeration on?

Signature

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

> I'm finding that using CONTAINS () and any word or phrase containing
> an ' does not work. It seems to split the phrase up instead of doing
[quoted text clipped - 18 lines]
> didn't seem to find anything recent that applied to my issue.
> Thanks for your time.

Reply to this Message

ocelot4401@gmail.com - 24 Oct 2007 18:37 GMT

I tried this idea before and go the same responses, pdf files with
either the word computer or the word technonolgy in them. NOT files
with the phrase "computer's technology" in them.

enumeration? how would this help and how would i turn it on?

> This is an indexing services question and an NT 4.0 Index Server 1 one at
> that. To make your query Windows 200X Indexing Services 2.0 compliant you
[quoted text clipped - 35 lines]
> > didn't seem to find anything recent that applied to my issue.
> > Thanks for your time.

Reply to this Message

ocelot4401@gmail.com - 24 Oct 2007 20:12 GMT

ok, changed my code back SQL now looks like:

SELECT DocTitle, Filename, Vpath, Size, Write, Characterization, Rank
FROM SCOPE() WHERE CONTAINS ('"computer''s hardware"') AND (Filename
LIKE '%_%_%_%.pdf')

still returns the wrong results.

>.<

i was hoping that was the issue

>.<

On Oct 24, 1:37 pm, ocelot4...@gmail.com wrote:

> I tried this idea before and go the same responses, pdf files with
> either the word computer or the word technonolgy in them. NOT files
[quoted text clipped - 41 lines]
> > > didn't seem to find anything recent that applied to my issue.
> > > Thanks for your time.

Reply to this Message

Hilary Cotter - 09 Nov 2007 12:35 GMT

set objCommand.Properties("Always use content index")=True

Signature

>I tried this idea before and go the same responses, pdf files with
> either the word computer or the word technonolgy in them. NOT files
[quoted text clipped - 43 lines]
>> > didn't seem to find anything recent that applied to my issue.
>> > Thanks for your time.

Reply to this Message