On Oct 24, 12:22 pm, "Hilary Cotter" <hilary.cot...@gmail.com> wrote:
> 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?
> --
> 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<ocelot4...@gmail.com> wrote in message
>
> news:1193159982.075561.183280@i13g2000prf.googlegroups.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
> > 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.

>.<

>.<

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
> with the phrase "computer's technology" in them.
>
> enumeration? how would this help and how would i turn it on?
>
> On Oct 24, 12:22 pm, "Hilary Cotter" <hilary.cot...@gmail.com> wrote:
>
> > 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?
> > --
> > 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<ocelot4...@gmail.com> wrote in message
>
> >news:1193159982.075561.183280@i13g2000prf.googlegroups.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
> > > 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.

<ocelot4401@gmail.com> wrote in message
news:1193159982.075561.183280@i13g2000prf.googlegroups.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
> 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.
>