Grab text near match in fulltext

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pacific Fox - Web Design Brisbane - 19 Dec 2007 01:37 GMT

Is there a way to grab a bit of text near the first word the fulltext
search matches?

We're currently showing a summary to people, which is written by the
user, but obviously does not contain the keyword someone searched for.
And people think the search results are incorrect, but if they click
through they'll find the keyword is there.

I'm thinking MS SQL is not able to do this. Is there some other
product out there that does? We're using MS SQL 2005 Ent and
ColdFusion

Thanks in advance.

Reply to this Message

Hilary Cotter - 19 Dec 2007 13:21 GMT

You have to code your own solution.

You might want to talk to michal at devmasters.cz. He has a solution. I am
cc'ing him in this communication so he can jump in and help you.

Signature

http://www.zetainteractive.com - Shift Happens!

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Is there a way to grab a bit of text near the first word the fulltext
> search matches?
[quoted text clipped - 9 lines]
>
> Thanks in advance.

Reply to this Message