Flexible database searching

In the ASP forum, I have posted a version of a script that does a flexible search over multiple fields in a database table.

I have decided to post the full version 1 here in case anyone wants to use it.

This is not a cross post, this version has more functionality than the other.

Features:

Search across multiple text based fields
Order by multiple fields (ascending and descending)
Return a limited set of fields (or the whole table) in a recordset
Recordset paging
Strip out disallowed words as defined in a database table
Two types of search
1. Each field having all words in any order
2. Each field having any word in any order

I hope one or two people find this useful

Elija

looks very nice, full code samples are always welcome. I added link to this thread in the sticky over here: http://forums.aspfree.com/showthrea...2652#post182652

keep up the good job!!

What's this "Reputation Power?"
Makes a person more credible?

the reputation Power determines how many reputation Points you give (or take) when you Agree (or Disagree) to someone's post. for example, if I Agree to post of yours I give you 6 reputation points. you can see how many points you have in the user CP. reputation points does not have any direct effect, it's just another cool feature like avatar, karate belt and such and there's even Hall Of Fame in the Free Lounge.

Cool feature! I like it. Fun.

This is a new version of the flexisearch.

It has a bug fix. When the disallowed words table is empty the stripDisallowedWords function returns the original word list, rather than falling over.

Thanks to webfort for testing / debugging help

Elija