Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Highlight text replaced through theasurus file

 
   Database Help (Home) -> Full Text RSS
Next:  Changing text characters.  
Author Message
Matt

External


Since: Feb 07, 2008
Posts: 67



(Msg. 1) Posted: Tue Nov 11, 2008 9:03 am
Post subject: Highlight text replaced through theasurus file
Archived from groups: microsoft>public>sqlserver>fulltext (more info?)

I am using the FTS to run a search through an web application. (asp.net)
Is it possible to pickup that the theasurus file has replaced a search word
so that I can indicate this to the user via the website?
thanks.

 >> Stay informed about: Highlight text replaced through theasurus file 
Back to top
Login to vote
Hilary Cotter

External


Since: Jan 16, 2008
Posts: 143



(Msg. 2) Posted: Wed Nov 19, 2008 3:31 am
Post subject: RE: Highlight text replaced through theasurus file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You will have to load the thesaurus file your self and parse it to make the
replacements. There is no mechanism provided by Microsoft which will tell you
which replacement/expansion term was used/replaced.

"Matt" wrote:

> I am using the FTS to run a search through an web application. (asp.net)
> Is it possible to pickup that the theasurus file has replaced a search word
> so that I can indicate this to the user via the website?
> thanks.

 >> Stay informed about: Highlight text replaced through theasurus file 
Back to top
Login to vote
Simon Sabin

External


Since: Mar 01, 2007
Posts: 15



(Msg. 3) Posted: Wed Dec 17, 2008 8:25 pm
Post subject: Re: Highlight text replaced through theasurus file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hello Matt,

If Using SQL2008 you can use the sys.dm_fts_parser function


Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons


> I am using the FTS to run a search through an web application.
> (asp.net)
> Is it possible to pickup that the theasurus file has replaced a search
> word
> so that I can indicate this to the user via the website?
> thanks.
 >> Stay informed about: Highlight text replaced through theasurus file 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
How can I rename full text indexing file name - Can any one point me to right direction for renaming of full text index file name. I have full text indexing on a table and I have to rename this file without droping and receating full text indexing. For example SELECT name, physical_name FROM..

Full-Text Limitation in SQL 2000? - Hello, Is there a limit to the number of databases on a single SQL Server that can be Full-Text enabled? I have 15 databases all with Full-Text search working fine. Now I just made a 16th database and enabled Full-Text in the usuall manner and nothing..

Can Full Text Searching do this???? - 1. Create a robust search engine able searching of information across all types of content. 2. Support Open Search specification 3. content indexer applying A-Z indexing model and establish keyword metadata references. 4. performs naive Bayes..

returning searched text - Given a search string of "this is a sample of what I want to find" for example, I want to know what sql fts actually searched for- i.e. the string w/out the noise words. Is there a built in function to trim out the noise words? Thanks! Jeff

periods in full text - Hello - We are using: Windows Server 2003 SP2 SQL Server 2000 SP2 Data is stored using periods such as 12.XT.1234.1 I realize that the . is a punctuation, but how exatly does it search for this when I use the following contains query: select count(*)...
   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



[ Contact us | Terms of Service/Privacy Policy ]