|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
May 7th, 2005, 05:44 PM
|
||||
|
||||
|
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
|
|
#2
May 7th, 2005, 06:15 PM
|
||||
|
||||
|
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!! 
|
|
#4
May 8th, 2005, 09:58 AM
|
||||
|
||||
|
Quote:
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.
|
|
#6
May 13th, 2005, 05:41 PM
|
||||
|
||||
|
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
|
|
#7
August 13th, 2009, 05:57 PM
|
|||
|
|||
|
Elija,
Looking for a bit of help in implementing something alongside your code. What I'm looking to do is add a clickable link in the search results that leads to another ASP page that we have that displays the editable fields for the record. It would have to be tied to the Project ID. Here is the code snippet that shows up on our default project view so that you can click to edit the record. Code:
<a href="edit.asp?ProjectID=<%= Recordset1.Fields.Item("ProjectID").Value %>"><%=(Recordset1.Fields.Item("ProjectID").Value)%></a>
|
|
| Viewing: ASP Free Forums > Programming > Code Bank > Flexible database searching |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
