Highlight Keywords

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

guate911 - 17 May 2007 17:01 GMT

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

Reply to this Message

Hilary Cotter - 23 May 2007 14:10 GMT

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

>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
[quoted text clipped - 9 lines]
>
> Thanks

Reply to this Message