|
Home > Archive > IIS Index Server > February 2004 > Why doesn't this query pull back results
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Why doesn't this query pull back results
|
|
| IrishManInUsa 2004-01-24, 3:35 pm |
| Hi Everyone,
I am indexing a site using IndexServer that comes with a Windows2000 server
machine, and if I type in 97635-00 I get back results and if I type in 97635
I get back no results.
I was under the impression that FreeText and Contains would pull back
results if you only enter in part of the string.....and I am not sure why it
does not work with the query down below.
SELECT DocTitle, Filename, Vpath, Size, Write, Characterization,
Rank,CONTAINS (Contents,'' ) FROM SCOPE('DEEP TRAVERSAL OF "/"') WHERE
(CONTAINS (CONTENTS,'"97635"' ) > 0 OR FREETEXT (CONTENTS,'"97635"' ) > 0)
OR Dockeywords like '%97635%' AND (Filename LIKE '%.html' OR Filename LIKE
'%.asp' OR Filename LIKE '%.pdf' OR Filename LIKE '%.doc' OR Filename LIKE
'%.xls' OR Filename LIKE '%.ppt' OR Filename LIKE '%.txt' OR Filename LIKE
'%.htm') ORDER BY Rank,DocTitle DESC
I scaled down the query to this one and still didn't any results....any help
would be appreciated
SELECT DocTitle, Filename, Vpath, Size, Write, Characterization,
Rank,CONTAINS (Contents,'' ) FROM SCOPE() WHERE (CONTAINS ('97635' ) > 0)
ORDER BY Rank,DocTitle DESC
Also.....I can't seem to pull back any results with the wildcard.......if
anyone has any ideas on how to solve this one....please drop me a
line....thanks in advance.
| |
| Irishmaninusa 2004-02-11, 10:35 am |
| hmmmm...still no ideas on this one....
"IrishManInUsa" <irishmaninusa@hotmail.com> wrote in message
news:u3S2I4v4DHA.2168@TK2MSFTNGP12.phx.gbl...
> Hi Everyone,
>
> I am indexing a site using IndexServer that comes with a Windows2000
server
> machine, and if I type in 97635-00 I get back results and if I type in
97635
> I get back no results.
>
> I was under the impression that FreeText and Contains would pull back
> results if you only enter in part of the string.....and I am not sure why
it
> does not work with the query down below.
>
> SELECT DocTitle, Filename, Vpath, Size, Write, Characterization,
> Rank,CONTAINS (Contents,'' ) FROM SCOPE('DEEP TRAVERSAL OF "/"') WHERE
> (CONTAINS (CONTENTS,'"97635"' ) > 0 OR FREETEXT (CONTENTS,'"97635"' ) > 0)
> OR Dockeywords like '%97635%' AND (Filename LIKE '%.html' OR Filename LIKE
> '%.asp' OR Filename LIKE '%.pdf' OR Filename LIKE '%.doc' OR Filename LIKE
> '%.xls' OR Filename LIKE '%.ppt' OR Filename LIKE '%.txt' OR Filename LIKE
> '%.htm') ORDER BY Rank,DocTitle DESC
>
>
>
> I scaled down the query to this one and still didn't any results....any
help
> would be appreciated
> SELECT DocTitle, Filename, Vpath, Size, Write, Characterization,
> Rank,CONTAINS (Contents,'' ) FROM SCOPE() WHERE (CONTAINS ('97635' ) > 0)
> ORDER BY Rank,DocTitle DESC
>
>
>
> Also.....I can't seem to pull back any results with the wildcard.......if
> anyone has any ideas on how to solve this one....please drop me a
> line....thanks in advance.
>
>
|
|
|
|
|