Full Text Search Result

FAQ

Profile

Full Text Search Result

Database Help (Home) -> Full Text

Next: Newbie Question on Variables

Author

Message

Vishal Dalsania

External

Since: Nov 30, 2008
Posts: 5

(Msg. 1) Posted: Mon Dec 01, 2008 11:25 am Post subject: Full Text Search Result Archived from groups: microsoft>public>sqlserver>fulltext (more info?)

Is it possible to retrive the search result to highlight the text where it found the text searched? Like google i mean. Thanks, Vishal >> Stay informed about: Full Text Search Result

Hilary Cotter

External

Since: Jan 16, 2008
Posts: 143

(Msg. 2) Posted: Mon Dec 01, 2008 11:25 am Post subject: RE: Full Text Search Result [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

You have to code this yourself. "Vishal Dalsania" wrote: > Is it possible to retrive the search result to highlight the text where it > found the text searched? > > Like google i mean. > > Thanks, > Vishal > > > >> Stay informed about: Full Text Search Result

Vishal Dalsania

External

Since: Nov 30, 2008
Posts: 5

(Msg. 3) Posted: Mon Dec 01, 2008 12:25 pm Post subject: Re: Full Text Search Result [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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 "Hilary Cotter" wrote in message > You have to code this yourself. > > "Vishal Dalsania" wrote: > >> Is it possible to retrive the search result to highlight the text where >> it >> found the text searched? >> >> Like google i mean. >> >> Thanks, >> Vishal >> >> >> >> Stay informed about: Full Text Search Result

Hilary Cotter

External

Since: Jan 16, 2008
Posts: 143

(Msg. 4) Posted: Mon Dec 01, 2008 12:25 pm Post subject: Re: Full Text Search Result [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

I meant containstable. What does your search paragraph look like? "Vishal Dalsania" wrote: > 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 > > "Hilary Cotter" wrote in message > > > You have to code this yourself. > > > > "Vishal Dalsania" wrote: > > > >> Is it possible to retrive the search result to highlight the text where > >> it > >> found the text searched? > >> > >> Like google i mean. > >> > >> Thanks, > >> Vishal > >> > >> > >> > > > >> Stay informed about: Full Text Search Result

Vishal Dalsania

External

Since: Nov 30, 2008
Posts: 5

(Msg. 5) Posted: Mon Dec 01, 2008 2:25 pm Post subject: Re: Full Text Search Result [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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 "Hilary Cotter" wrote in message >I meant containstable. > > What does your search paragraph look like? > > "Vishal Dalsania" wrote: > >> 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 >> >> "Hilary Cotter" wrote in message >> >> > You have to code this yourself. >> > >> > "Vishal Dalsania" wrote: >> > >> >> Is it possible to retrive the search result to highlight the text >> >> where >> >> it >> >> found the text searched? >> >> >> >> Like google i mean. >> >> >> >> Thanks, >> >> Vishal >> >> >> >> >> >> >> >> >> >> Stay informed about: Full Text Search Result

Smokey Grindel

External

Since: Jan 10, 2008
Posts: 63

(Msg. 6) Posted: Fri Dec 05, 2008 8:16 am Post subject: Re: Full Text Search Result [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

that's not an easy thing to code, trust me... "Vishal Dalsania" wrote in message > 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 > > "Hilary Cotter" wrote in message > >>I meant containstable. >> >> What does your search paragraph look like? >> >> "Vishal Dalsania" wrote: >> >>> 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 >>> >>> "Hilary Cotter" wrote in message >>> >>> > You have to code this yourself. >>> > >>> > "Vishal Dalsania" wrote: >>> > >>> >> Is it possible to retrive the search result to highlight the text >>> >> where >>> >> it >>> >> found the text searched? >>> >> >>> >> Like google i mean. >>> >> >>> >> Thanks, >>> >> Vishal >>> >> >>> >> >>> >> >>> >>> >>> > > >> Stay informed about: Full Text Search Result

Display posts from previous:

Related Topics:

Full text search can not return result - Hi all, In my case, I build a full text search query. like "select * from _tt_fields where contains(string,'"development group"')", when I click F5 then execute the sql, it returned the records, but when I click execute the query mor...

FULL TEXT SEARCH PROBLEM - I have a table which has a record T17.1.516.32 I try SELECT Urun_Ad as guUrun_Ad FROM TBL_URUNLER WHERE ( (CONTAINS(Urun_Ad, '"*t17.1.516.32*"' ) )) it returns T17.1.516.32 i try SELECT Urun_Ad as guUrun_Ad FROM TBL_URUNLER WHERE (..

Benchmark for Full Text Search - Hi, We are currently using a 3rd party Search Engine to search our application content in SQL server. Could someone please point me to Benchmark data for the FTS service? I am interested in switching to FTS even if the Performance numbers are..

Full text Pattern Search - Hi, Would below mentioned thing is possible in sqlserver 2005 full text. User Table - Table Id Description - Column name 1 'Mission Impossible' - a row I want to ge this row if the search criteria is 'pos'. it is simillar to ' %pos%' in like....

full text search problem!!.....help - hello my full text queries have suddenly stop functioning,when I press execute tab, its keep on saying "Executing query" for hours.Can any one tell me how to resolve this problem. I am using SQL server 2005.In the enterprise manager, I can see ...

	Database Help (Home) -> Full Text	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum