Problems With Fulltexttable

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phani Kumar - 07 Nov 2008 06:29 GMT

Hello sir
I am doing a job portal in asp.net .. database sql server
In that i am using FREETEXTtable query for searching my records..
If my cleints types like 'C' as search string it does not going to give any recors. because it is a NOISE WORD. But my Host rejected to delete the noise word c from the list.. When i try to use contains table its giving 'c++' but not c#
but freetexttable is not giving c and c++ and c#.. a+..

What i have to do,,, how can i get the results with out deleting noise words...

2) My second question is some times i am unable to get exact results .. why
like
WITH [peoplesurge_posting ORDERED BY ROWID] AS (SELECT ROW_NUMBER() OVER (ORDER BY rank desc ) AS ROWID,id,skills,cname,classification,state,metroarea,designation,rank FROM peoplesurge_posting as posting INNER JOIN freetexttable(peoplesurge_posting,(skills,cname,metroarea,state),'isabout(vb.net OR infosis OR Jaisalmer)' ) as frees ON frees.[key]= posting.[id] ) SELECT * FROM [peoplesurge_posting ORDERED BY ROWID]
This is my query

my result is

But here from my querey i should get results vb.net as skill and comapany as infosis
But here i am getting result like
1 78 c,c++,vb wipro IT/Telecom-Software Pradesh Udaipur Programmer 11
Above o am getting skill as c,c++,vb programmer and company as wipro
Not only in this issue i am getting not good results.. is fulltext is really good one

3) in lucenet we have a option that it creates a doument for connection and table
every time to goes to that doument gives us result.. is there any option in fulltext
Please give me answer as soon as possible

Thanks
Phani

Posted via DevelopmentNow.com Group
http://www.developmentnow.com/g/

Reply to this Message

Russell Fields - 07 Nov 2008 15:44 GMT

Phani,

1) If the noise word list cannot be changed, then you cannot get the words
in the noise word list. So, you are stuck. But perhaps you can negotiate.

There are many languages supported for full-text indexing. Perhaps they do
not want to edit the ENGLISH noise word list, but are willing to edit
Neutral or Thai. If so, then you can choose a different Word Breaker
language for the column of full-text data. (I use British English for no
noise words and English (actually American English) for noise words.)

2) You believe that you are searching for "vb.net", but you are actually
searching for "vb" or "net". The dot is a word breaker and it is breaking
that string into two words. Although you cannot get fulltext indexing to
index the dot you could make it into a phrase, for example:

INNER JOIN
freetexttable(peoplesurge_posting,(skills,cname,metroarea,state),'isabout("vb.net"
OR infosis OR Jaisalmer)' )

This would still find "vb net", "vb-net", "vb.net", et cetera, but would be
closer to what you are looking for.

3) No comment on this.

RLF

> Hello sir
> I am doing a job portal in asp.net .. database sql server
[quoted text clipped - 41 lines]
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com/g/

Reply to this Message

Hilary Cotter - 07 Nov 2008 15:50 GMT

1) in SQL 2005 is C is capitalized you should get the behavior you are
looking for whether c is on your noise word list or not. Note that searches
on c or C will not find anything. You might want to pre-parse your content
and replace c++, with C++, or CPLUSPLUS and then modify your search phrase
(to search on CPLUSPLUS).

2) I would not do your query the way you are issuing it. First it makes no
sense.
IsAbout is ignored in a freetext search, actually it is search upon.
Secondly you return the entire table in the last part of the statement.

3) are you referring to the phone company Luencet, or Lucene. With Luence I
think you are talking either about Luke or the way it hit highlights. WIth
Luke it searches for each word in the index to see if and where it is in the
document. Its very slow. The hit highlighting feature will mark up the
document, but you have to supply the document to it

> Hello sir
> I am doing a job portal in asp.net .. database sql server
[quoted text clipped - 30 lines]
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com/g/

Reply to this Message