Re: Grab text near match in fulltext

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.

--
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
"Pacific Fox - Web Design Brisbane" <tacofleur@xxxxxxxxx> wrote in message
news:63bbaacc-e8be-4280-9a98-5af5edbaa4ae@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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.


.

Relevant Pages

  • RE: Using an Object from a Current form for Criteria in a Query
    ... The keyword "Me" refers to the current form or report. ... a simple form with a textbox (which is named txtThisBox) and a button (which ... caption of the button to "SQL Ran" (I understand that this is not a likely ... Private Sub btnThisButton_Click ...
    (microsoft.public.access.formscoding)
  • Grab text near match in fulltext
    ... We're currently showing a summary to people, ... but obviously does not contain the keyword someone searched for. ... I'm thinking MS SQL is not able to do this. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Error when calling the OleDbDataAdapter.Fill() method
    ... Have you tried copying and pasting the query into an Access query ... it is caused by using a keyword as a fieldname in my database. ... Here is the SQL statement I am executing (I am using Microsoft Access as my ... SELECT headline,url,summary,updated FROM worldnews EXCEPT (SELECT ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Using an Object from a Current form for Criteria in a Query
    ... The keyword "Me" refers to the current form or report. ... a simple form with a textbox (which is named txtThisBox) and a button (which ... caption of the button to "SQL Ran" (I understand that this is not a likely ... Private Sub btnThisButton_Click ...
    (microsoft.public.access.formscoding)
  • Re: collations and Unicode string processing
    ... is called for each keyword. ... You can also gain some performance by forcing a binary collation in ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.programming)