Web Wiz Support and Community Forums : FULLTEXT SEARCH in WWF 8 ? https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 06:50:37 +0000 Fri, 10 Mar 2006 12:54:36 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=18663 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[FULLTEXT SEARCH in WWF 8 ? : Thanks Ritchie, I will look into...]]> https://forums.webwiz.net/fulltext-search-in-wwf-8_topic18663_post101023.html#101023 Author: WebWiz-Bruce
Subject: 18663
Posted: 10 March 2006 at 12:54pm

Thanks Ritchie, I will look into such a feature for the SQL Server version.]]> Fri, 10 Mar 2006 12:54:36 +0000 https://forums.webwiz.net/fulltext-search-in-wwf-8_topic18663_post101023.html#101023 <![CDATA[FULLTEXT SEARCH in WWF 8 ? : Greetings Borg! In WWF 8 MSSQL...]]> https://forums.webwiz.net/fulltext-search-in-wwf-8_topic18663_post100985.html#100985 Author: Ritchie
Subject: 18663
Posted: 09 March 2006 at 7:22pm

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? Wink
]]> Thu, 09 Mar 2006 19:22:47 +0000 https://forums.webwiz.net/fulltext-search-in-wwf-8_topic18663_post100985.html#100985