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)
 Needing search help ...
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Etymon
Advanced Member

United States
2385 Posts

Posted - 16 November 2007 :  07:30:26  Show Profile  Visit Etymon's Homepage
I'm trying to figure out a way to not include search terms that are found within a hyperlink while searching posts.

For example, if I were searching for the word blue, I would not expect to find it hidden in a link that is hidden beneath text such as like this (Note: I had to add a space after the [ bracket to avoid my example being formatted by the forum code):

[ url="http://www.blue.com"]This is my web site[ /url]

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 16 November 2007 :  08:33:05  Show Profile  Visit HuwR's Homepage
not much you can do about that I'm afraid since the link contains the word you are searching for it will allways find it, SQL does not know anything about forumcode so has no way of skipping it when searching
Go to Top of Page

Etymon
Advanced Member

United States
2385 Posts

Posted - 16 November 2007 :  08:34:29  Show Profile  Visit Etymon's Homepage
k, thanks, Huw ... one can always hope that a workaround is in our midst!
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 16 November 2007 :  08:36:56  Show Profile  Visit HuwR's Homepage
quote:
Originally posted by Etymon

k, thanks, Huw ... one can always hope that a workaround is in our midst!



very doubtful it would require a significant amount of code and a lot more processing time to filter out such results as it would have to be done after the search query has returned a resultset
Go to Top of Page

Etymon
Advanced Member

United States
2385 Posts

Posted - 16 November 2007 :  08:40:01  Show Profile  Visit Etymon's Homepage
Isn't there a way to filter the results that rest between the [ url ] and [ /url ] tags?
Go to Top of Page

Etymon
Advanced Member

United States
2385 Posts

Posted - 16 November 2007 :  08:41:07  Show Profile  Visit Etymon's Homepage
Or even have a notice like:

<- (This link contains search results)

Edited by - Etymon on 16 November 2007 08:41:32
Go to Top of Page

MarcelG
Retired Support Moderator

Netherlands
2625 Posts

Posted - 17 November 2007 :  10:28:44  Show Profile  Visit MarcelG's Homepage
The other option would be to treat each search term as a seperate word, so instead of looking for "blue" in the database, you'd be looking for all instances of the word "blue", at the start of a line, surrounded by spaces, followed by a dot, question mark, exclamation mark or a comma.

You could use the advanced search page to select this type of search, or make it default if only one word is provided in the search box.

Just an idea.

portfolio - linkshrinker - oxle - twitter

Edited by - MarcelG on 17 November 2007 10:29:00
Go to Top of Page

MarcelG
Retired Support Moderator

Netherlands
2625 Posts

Posted - 17 November 2007 :  10:34:28  Show Profile  Visit MarcelG's Homepage
Here's a regexp approach: http://www.tek-tips.com/viewthread.cfm?qid=1347547&page=1

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

MarcelG
Retired Support Moderator

Netherlands
2625 Posts

Posted - 17 November 2007 :  10:39:47  Show Profile  Visit MarcelG's Homepage
And this page might be helpful too: http://heap.nologin.net/aspsec.html

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

Etymon
Advanced Member

United States
2385 Posts

Posted - 19 November 2007 :  03:23:15  Show Profile  Visit Etymon's Homepage
Hi Marcel,

Hey, thanks for the input there. I'll try the options and see what I come up with.

Cheers,

Etymon
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.38 seconds. Powered By: Snitz Forums 2000 Version 3.4.07