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

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Discussions (General)
 disabling common words in the search engine?
 New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

Maarten
Starting Member

Netherlands
22 Posts

Posted - 16 August 2002 :  13:28:07  Show Profile  Visit Maarten's Homepage  Send Maarten an ICQ Message
It might be an idea to disable (block) common words (the and an etc) in the searchengine query's. Also i am able to search for '%' (everything in SQL). A couple of these requests can kill your hosts cpu time or even stop answering requests.

I don't really know if this is fixed in a later version or versions that are in development at this moment but it might be better to block those things.

I'm using version 3.3.05 myself and i am able to search for '%'.

Is this a known issue?

A bartender is just a pharmacist with a limited inventory.

Nathan
Help Moderator

USA
7664 Posts

Posted - 16 August 2002 :  13:52:07  Show Profile  Visit Nathan's Homepage
Doesn't look like that has been fixed. Its kinda fun though.

Nathan Bales
CoreBoard | Active Users Download
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 16 August 2002 :  14:13:22  Show Profile
We would just need a list of all characters that would need to be filtered out.

I'd also like to set a minimum # of characters for the search words, maybe at least 5?
Go to Top of Page

davemaxwell
Access 2000 Support Moderator

USA
3020 Posts

Posted - 16 August 2002 :  14:22:06  Show Profile  Visit davemaxwell's Homepage  Send davemaxwell an AOL message  Send davemaxwell an ICQ Message  Send davemaxwell a Yahoo! Message
If it's five, you couldn't search for things like XML, .NET, CSS, v3.4, etc...

Dave Maxwell
Barbershop Harmony Freak
Go to Top of Page

Maarten
Starting Member

Netherlands
22 Posts

Posted - 16 August 2002 :  14:27:09  Show Profile  Visit Maarten's Homepage  Send Maarten an ICQ Message
If things are really bad you might even fill in sql queries that you really don't want a user to do. But i guess that is being checked already?

A bartender is just a pharmacist with a limited inventory.
Go to Top of Page

Nathan
Help Moderator

USA
7664 Posts

Posted - 16 August 2002 :  14:43:08  Show Profile  Visit Nathan's Homepage
oh yeah

Nathan Bales
CoreBoard | Active Users Download
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 16 August 2002 :  14:46:39  Show Profile
this is all that is being checked for:

fString = Replace(fString, "'", "''")
fString = replace(fString, ">", ">")
fString = replace(fString, "&lt;", "<")

Go to Top of Page

Aaron S.
Average Member

USA
985 Posts

Posted - 16 August 2002 :  14:54:18  Show Profile  Visit Aaron S.'s Homepage
A minimum of 3 characters should suffice. That is what I use on my other sites for search.

--Aaron


DOWNLOAD GREAT NEW MODS HERE
Go to Top of Page

davemaxwell
Access 2000 Support Moderator

USA
3020 Posts

Posted - 16 August 2002 :  15:08:00  Show Profile  Visit davemaxwell's Homepage  Send davemaxwell an AOL message  Send davemaxwell an ICQ Message  Send davemaxwell a Yahoo! Message
quote:
Originally posted by Aaron S.

A minimum of 3 characters should suffice. That is what I use on my other sites for search.

--Aaron





As long as you ignore words like the, why, etc.

Dave Maxwell
Barbershop Harmony Freak
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 16 August 2002 :  15:08:02  Show Profile  Visit HuwR's Homepage
not sure it would help, and it would certainly irritate me if I could no longer search for

a e i o u

MVC .net dev/test site | MVC .net running on Raspberry Pi
Go to Top of Page

davemaxwell
Access 2000 Support Moderator

USA
3020 Posts

Posted - 16 August 2002 :  15:08:47  Show Profile  Visit davemaxwell's Homepage  Send davemaxwell an AOL message  Send davemaxwell an ICQ Message  Send davemaxwell a Yahoo! Message
quote:
Originally posted by HuwR

not sure it would help, and it would certainly irritate me if I could no longer search for

a e i o u



And sometimes y?

Dave Maxwell
Barbershop Harmony Freak
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 16 August 2002 :  15:14:56  Show Profile  Visit HuwR's Homepage
oh yeah, forgot that on

MVC .net dev/test site | MVC .net running on Raspberry Pi
Go to Top of Page

Aaron S.
Average Member

USA
985 Posts

Posted - 16 August 2002 :  15:17:03  Show Profile  Visit Aaron S.'s Homepage
Of course why not just have it be an admin function:

1. Minimum length (if any)
2. Excluded words

Should be an easy MOD if it is not something we want in the core code.

--Aaron


DOWNLOAD GREAT NEW MODS HERE
Go to Top of Page

Nathan
Help Moderator

USA
7664 Posts

Posted - 16 August 2002 :  15:55:17  Show Profile  Visit Nathan's Homepage
quote:
Originally posted by davemaxwell

quote:
Originally posted by HuwR

not sure it would help, and it would certainly irritate me if I could no longer search for

a e i o u



And sometimes y?



And on very rare occations, w

Nathan Bales
CoreBoard | Active Users Download
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 16 August 2002 :  16:55:39  Show Profile
You can look in \winnt\system32 on a computer with SQL Server installed and find files that the server uses to identify "noise" words.

The file(s) are named "noise.zzz" where the zzz is by language.

I think there are more noise word files in the free text search folder in the mssql program files, too.

======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page

Deleted
deleted

4116 Posts

Posted - 16 August 2002 :  17:48:04  Show Profile
Doug, thank you for the info... I think $ is used for end of file, with the ones below that are readied for cut-paste. It was interesting to see that English file is 1kb and German one is 147 kb...

Stop the WAR!
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 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.18 seconds. Powered By: Snitz Forums 2000 Version 3.4.07