FULLTEXT SEARCH in WWF 8 ?

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Greetings Borg! 
In WWF 8 MSSQL the version very simply can add fulltext search. It can repeatedly lower loading on a server and raise efficiency of search in particular: It is necessary to replace only 3 lines in a file search_process.asp:

strSQLwhereKeywords = strSQLwhereKeywords & " (" & strTableFieldName & " LIKE '%" & strSearchKeywords & "%')"

Replace:

strSQLwhereKeywords = strSQLwhereKeywords & " CONTAINS(" & strTableFieldName & " , '""" & strSearchKeywords & """')"

And 

strSQLwhereKeywords = strSQLwhereKeywords & "AND (" & strTableFieldName & " LIKE '%" & strSearchKeywords & "%')"

Replace:

strSQLwhereKeywords = strSQLwhereKeywords & " AND CONTAINS(" & strTableFieldName & " , '""" & strSearchKeywords &

And

strSQLwhereKeywords = strSQLwhereKeywords & strTableFieldName & " LIKE '%" & sarySearchWord(intCurrentRecord) & "%'"

Replace:

strSQLwhereKeywords = strSQLwhereKeywords & " CONTAINS(" & strTableFieldName & " , '""" & sarySearchWord(intCurrentRecord) & """')"

 In an administrative part of a forum it is possible to add function of inclusion of fulltext search for MSSQL versions of a forum very much it would be desirable that this opportunity was... 

What you will tell, Borg? 