Problems With Fulltexttable

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 Groups
http://www.developmentnow.com/g/

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
"Phani Kumar" wrote:

> 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 Groups
> http://www.developmentnow.com/g/
>