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