Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 Search for exact word
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

endomorph
Junior Member

United Kingdom
128 Posts

Posted - 05 July 2005 :  15:05:53  Show Profile
Is there any way or MOD or code change that will facilitate the searching of exact words.

I have members who may search for 'RMI' but of course posts containing 'determining' come up.

This is really frustrating when looking for companies.

Any help / advice ?

Need help with your Snitz ? Most Snitz & ASP custom coding undertaken. Email for info | Search Engine Optimisation

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 05 July 2005 :  16:12:37  Show Profile  Send ruirib a Yahoo! Message
I don't think there is much that you can do about it. That's just a consequence of several things: the lack of a search language, that allows you to distinguish, among other things, between whole words or parts of words and the way Access / SQL Server or MySQL allow searching in text fields.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

MarcelG
Retired Support Moderator

Netherlands
2625 Posts

Posted - 05 July 2005 :  16:14:09  Show Profile  Visit MarcelG's Homepage
Interesting question.
It's somewhere in this piece of code, afaik.
		if Request.Form("Search") <> "" then
			if CInt(strSLDoLog) = 1 then
			  Call AddSearchToDB()
			  Call AddKeywordsToDB()
			  Call AddQueriesToDB()
			end if	
			keywords = split(Request.Form("Search")), "#")
			keycnt = ubound(keywords)
			for i = 0 to keycnt
				if i = 0 then
					strKeywords = keywords(i)
				else
					strKeywords = strKeywords & "," & keywords(i)
				end if
			next
			if strAndOr = "phrase" then strKeyWords = replace(strKeyWords,",","+")
			SearchLink = "&SearchTerms=" & chkString(strKeyWords,"search")
		end if

But where....What about if we would add a space before and after every keyword ?
So, instead of looking for "RMI" we'd be looking for " RMI " ?
Wouldn't that solve this issue partly ?

portfolio - linkshrinker - oxle - twitter

Edited by - MarcelG on 05 July 2005 16:15:12
Go to Top of Page

MarcelG
Retired Support Moderator

Netherlands
2625 Posts

Posted - 05 July 2005 :  16:17:07  Show Profile  Visit MarcelG's Homepage
Whoops...it's not in just that piece of code...
I see that the actual SQL queries make use of the original Request.Form("Search") again....

portfolio - linkshrinker - oxle - twitter
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 05 July 2005 :  17:17:09  Show Profile  Send ruirib a Yahoo! Message
quote:
Originally posted by marcelgoertz

Whoops...it's not in just that piece of code...
I see that the actual SQL queries make use of the original Request.Form("Search") again....


They do. You need to be able to specify whole words or word parts for your search. That is not available now.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.43 seconds. Powered By: Snitz Forums 2000 Version 3.4.07