FULLTEXT SEARCH in WWF 8 ?
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=18663
Printed Date: 13 April 2026 at 6:52am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: FULLTEXT SEARCH in WWF 8 ?
Posted By: Ritchie
Subject: FULLTEXT SEARCH in WWF 8 ?
Date 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?
 |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 10 March 2006 at 12:54pm
| Thanks Ritchie, I will look into such a feature for the SQL Server version. |