Full Text Search Result

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vishal Dalsania - 01 Dec 2008 15:59 GMT

Is it possible to retrive the search result to highlight the text where it
found the text searched?

Like google i mean.

Thanks,
Vishal

Reply to this Message

Hilary Cotter - 01 Dec 2008 16:06 GMT

You have to code this yourself.

> Is it possible to retrive the search result to highlight the text where it
> found the text searched?
[quoted text clipped - 3 lines]
> Thanks,
> Vishal

Reply to this Message

Vishal Dalsania - 01 Dec 2008 16:22 GMT

Thank you for the reply.

How do i code it? Because i am querying a binary field in SQL server which
contains files of type word, excel, powerpoint and PDF.

Is there any starting point for this?

Thanks,
Vishal

> You have to code this yourself.
>
[quoted text clipped - 6 lines]
>> Thanks,
>> Vishal

Reply to this Message

Hilary Cotter - 01 Dec 2008 17:15 GMT

I meant containstable.

What does your search paragraph look like?

> Thank you for the reply.
>
[quoted text clipped - 16 lines]
> >> Thanks,
> >> Vishal

Reply to this Message

Vishal Dalsania - 01 Dec 2008 18:19 GMT

My column is Image data type with binary data. It contains word, excel,
powerpoint and PDF files.

Here is my search query

SELECT doc.DocumentID, doc.DocData, doc.DocName, doc.DocText, doc.Extension,
ftKey.*

FROM tblDocuments AS doc

INNER JOIN FREETEXTTABLE(tblDocuments, DocData, 'search_string') AS ftKey ON
doc.DocumentID = ftKey.[KEY] ORDER BY Rank DESC

Thanks,

Vishal

>I meant containstable.
>
[quoted text clipped - 22 lines]
>> >> Thanks,
>> >> Vishal

Reply to this Message

Smokey Grindel - 05 Dec 2008 13:16 GMT

that's not an easy thing to code, trust me...

> My column is Image data type with binary data. It contains word, excel,
> powerpoint and PDF files.
[quoted text clipped - 39 lines]
>>> >> Thanks,
>>> >> Vishal

Reply to this Message