ok I will post no code this time. I need help I have tried a half of dozen methods and they all only work half way. I need to create a search page that searches on all keywords in a textbox. I have tried split functions, like commands, freetext catalogs.
I want to go with the free text search.
How?
Has anyone used a freetext search in asp or c#? please post some code I re arrange it or let me know how to pass the freetext search param to the sql server....
Please....
The detailed explanation of the Full text feature of SQL Server is out of the scope of this post. Visit below links to understand the feature and how to implement it.
http://msdn2.microsoft.com/en-us/library/ms142547.aspx
http://technet.microsoft.com/en-us/sqlserver/bb331773.aspx
http://www.eggheadcafe.com/articles/20010422.asp
http://www.sql-server-performance.com/articles/all/tb_search_optimization_p1.aspx
Some links are for SQL 2000 and some for SQL 2005. Feel free to ask any queries on this feature if you've any doubts after studying the concept.
Hope this will help.
|||http://forums.asp.net/p/801329/803263.aspx
Look at aptbid's third post in the thread. His SP splits the words in the searchterm and then returns ranked results based on the position of the search term in the fields searched. Obviously you will need to adapt the table and field names to your environment.
the problem was that sql server 2005 does not like to auto populate I had to turn change tracking to off the do a incremental population this worked happens on two different machine.
No comments:
Post a Comment