Very Computer

Hello everyone!

You know, I'm new to the Full-Text in the SQL Server and Index Service, and
am a bit at loss as to which does what.

Well, my question is this:
I have many (large) documents in the image column of the SQL Server (2000)
table. Now I want to make a search on them and highlight the hits,
outputting not the whole document, but a short context of the hit ( like
Google does ).

One way I found is to use the Webhits.dll. The problems are:
1) It is needed to extract the file with the hit to the disk, which is bad,
as the file may be large.
2) I haven't managed the highlight feature to work. The .htw file outputs
the document itself ( it's stored in the virtual directory of the IIS ), but
no hits are highlighted: in face, the .htw says there are NO hits...

Any help would be greatly appreciated.

Thanks,
  Koly

the problem is that you want to highlight hits to your search phrase.  At
first glance this seems trivial, all you have to do is to go through your
content and replace hits to your search phrase with some formatting in front
of and after the search phrase to highlight it.  The problem is that you
have matches to plural forms and other inflectional forms in freetext
queries.  So a simple search and replace will not capture all the hits,
especially when you consider plurals like goose and geese, or mouse and
mice, or verb forms that are totally irregular like am and is.

If you want to run your page/row through index server hit highlighting you
will have to extract your row into a page, and then run it through
webhits.dll - which provides the hit highlighting function.  You have to do
this through manually clicking a hyperlink.

--
Hilary
www.iisfaq.com

Quote:> Hello everyone!

> You know, I'm new to the Full-Text in the SQL Server and Index Service,
and
> am a bit at loss as to which does what.

> Well, my question is this:
> I have many (large) documents in the image column of the SQL Server (2000)
> table. Now I want to make a search on them and highlight the hits,
> outputting not the whole document, but a short context of the hit ( like
> Google does ).

> One way I found is to use the Webhits.dll. The problems are:
> 1) It is needed to extract the file with the hit to the disk, which is
bad,
> as the file may be large.
> 2) I haven't managed the highlight feature to work. The .htw file outputs
> the document itself ( it's stored in the virtual directory of the IIS ),
but
> no hits are highlighted: in face, the .htw says there are NO hits...

> Any help would be greatly appreciated.

> Thanks,
>   Koly

Quote:> [...] So a simple search and replace will not capture all the hits,
> especially when you consider plurals like goose and geese, or mouse and
> mice, or verb forms that are totally irregular like am and is.

Yes, I know that this is a problem. Actually, my question was: what to do
then. Isn't there some way to do the highlighting without extracting the
file from the SQL Server table?

Quote:> If you want to run your page/row through index server hit highlighting you
> will have to extract your row into a page, and then run it through
> webhits.dll - which provides the hit highlighting function.  You have to
do
> this through manually clicking a hyperlink.

That's OK, but I don't seem to get how to use it. For example, there is a
file Cart.inc in my virtual directory, which contains the word 'Cart'.
To highlight the word 'Cart' in it ( there is this word inside ) I use the
following code:

'Code start

    WebHitsQuery = "CiWebHitsFile=" & "/L2kFX/Cart.inc"

    WebHitsQuery = WebHitsQuery & "&CiRestriction=" & Server.URLEncode(
"Cart" )

  Response.Write( WebHitsQuery ) 'Debug output

%>

<a href="http://localhost/L2kFX/Noname2.htw?<%= WebHitsQuery
%>&CiHiliteType=Full">Highlight Full</a>

<BR>

<%
Response.Write( "CiWebHitsFile=/L2KFX/Cart.inc&CiRestriction=Cart" ) //debug
info
%>
<a
href="http://localhost/L2kFX/qfullhit-r.htw?CiWebHitsFile=/L2KFX/Cart.inc&Ci
Restriction="Cart"">123</a>

'Code End

Anything wrong here? The 'Cart' doesn't seem to be found. Or do I have to
start the Index Servie first? If so, why doesn't it tell me so?

Thanks,
  Koly

See answers in line

Quote:>-----Original Message-----
>> [...] So a simple search and replace will not capture
all the hits,
>> especially when you consider plurals like goose and
geese, or mouse and
>> mice, or verb forms that are totally irregular like am
and is.

>Yes, I know that this is a problem. Actually, my question
was: what to do
>then. Isn't there some way to do the highlighting without
extracting the
>file from the SQL Server table?

no, maybe there will be in the SQL.NET file system

Quote:

>> If you want to run your page/row through index server

hit highlighting you

Quote:>> will have to extract your row into a page, and then run
it through
>> webhits.dll - which provides the hit highlighting

function.  You have to

Quote:>do
>> this through manually clicking a hyperlink.

>That's OK, but I don't seem to get how to use it. For
example, there is a
>file Cart.inc in my virtual directory, which contains the
word 'Cart'.
>To highlight the word 'Cart' in it ( there is this word
inside ) I use the
>following code:

>'Code start

>    WebHitsQuery = "CiWebHitsFile=" & "/L2kFX/Cart.inc"

>    WebHitsQuery = WebHitsQuery & "&CiRestriction=" &
Server.URLEncode(
>"Cart" )

>  Response.Write( WebHitsQuery ) 'Debug output

>%>

><a href="http://localhost/L2kFX/Noname2.htw?<%=
WebHitsQuery
>%>&CiHiliteType=Full">Highlight Full</a>

><BR>

><%
>Response.Write

( "CiWebHitsFile=/L2KFX/Cart.inc&CiRestriction=Cart" ) //de
bug

Quote:>info
>%>
><a
>href="http://localhost/L2kFX/qfullhit-r.htw?

CiWebHitsFile=/L2KFX/Cart.inc&Ci

Quote:>Restriction="Cart"">123</a>

>'Code End

>Anything wrong here? The 'Cart' doesn't seem to be found.
Or do I have to
>start the Index Servie first? If so, why doesn't it tell

me so?
you need index server running in order to do this.

Quote:>Thanks,
>  Koly

>.

Quote:> See answers in line

Eeerrrm... Pardon my ignorance, but what does that mean?

Thanks,
  Koly

Koly,

Hilary meant that she has answered in tandem with your statements.Lemme
reproduce those..

Isn't there some way to do the highlighting without
extracting the

Quote:>file from the SQL Server table?

no, maybe there will be in the SQL.NET file system  ---> Hilary's answer.

Quote:>Anything wrong here? The 'Cart' doesn't seem to be found.
Or do I have to
>start the Index Servie first? If so, why doesn't it tell

me so?
you need index server running in order to do this.---> Hilary's answer.

Pls double-check the perv.reply...I might have missed some.
Dinesh.

Quote:> > See answers in line

> Eeerrrm... Pardon my ignorance, but what does that mean?

> Thanks,
>   Koly

Oops! I meant '.....he has answered....'

Dinesh.

Quote:> Hilary meant that she has answered in tandem with your statements.Lemme
> reproduce those..

Thanks!

Quote:> >Anything wrong here? The 'Cart' doesn't seem to be found.
> Or do I have to
> >start the Index Servie first? If so, why doesn't it tell
> me so?
> you need index server running in order to do this.---> Hilary's answer.

Nope, running Indexing Service doesn't help the situation. Any ideas??

Thanks,
  Koly

Quote:> Hilary meant that she has answered in tandem with your statements.Lemme
> reproduce those..

Thanks!

Quote:> >Anything wrong here? The 'Cart' doesn't seem to be found.
> Or do I have to
> >start the Index Servie first? If so, why doesn't it tell
> me so?
> you need index server running in order to do this.---> Hilary's answer.

Nope, running Indexing Service doesn't help the situation. Any ideas??

Thanks,
  Koly