Re: Highlight Keywords

Tech-Archive recommends: Fix windows errors by optimizing your registry

You have to implement your own version of Porter stemmer algorithm for this.
You can use Indexing Services for this, here is a link describing how to do
this.

http://www.indexserverfaq.com/sqlhithighlighting.htm

"guate911" <guatemala911@xxxxxxxxx> wrote in message
news:1179417689.771131.84700@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I am using asp.net (C#) to create full text searching using SQL Server
2005 in our application. Everything is working fine, but I am trying
to highlight the resultset keywords from the full text results. Can
sql server provide you with a way to highlight the keywords from the
full text search?

I was able to kind of hack it by programatically replacing my keyword
search terms with the sql server resultset. However, when I do certain
searches, like "Frank's", sql server will return Frank using my
CONTAINS query, and I want the other results like "Frank" to be
highlighted too. Anyone know a good way to go about doing this?

Thanks



.

Relevant Pages

  • Highlight Keywords
    ... I am using asp.net to create full text searching using SQL Server ... to highlight the resultset keywords from the full text results. ... and I want the other results like "Frank" to be ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Number of documents vs rank in FTS
    ... especially if I start writing procedures to query the index using ... document frequency of a boolean query in SQL server*, ... > document collection or the frequency that words occur compared to the ... >> frequency to penalize the number of occurrences for keywords common ...
    (microsoft.public.sqlserver.fulltext)
  • Re: FreeTextTable on image column of document metadata
    ... If you're using SQL Server 7.0, you are limited to extracting the text from ... store binary files (MS word, MS Excel, Adobe PDF files, etc.) in an column ... Can I assume that if you search on keywords that you know to be in the body ... contains that keyword returned in your CONTAINS or FREETEXT query? ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Syntax coloring: SERVICE
    ... T-SQL is completely diluted with them. ... I know that SQL Server is confusing here. ... As I wrote, I just remembered that there exists many things in TSQL which actually are documented as keywords, but still work as unqualified identifiers. ...
    (microsoft.public.sqlserver.tools)
  • RE: Text Highlight
    ... I am affraid that excel will not allow you to change the format of only part ... of a cell. ... Sub highlight() ... > keywords is listed in a seperate workbook in the same Excel file. ...
    (microsoft.public.excel.programming)