Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Jul 2002
    Location
    Bunbury W.A
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Searching through a string

    It would seem that I need a powerfull string manipulation Function

    If I get the query string (Search string) from a 'Form' could be "How do I remove a desktop icon" then get the words to search against, from the 'Keywords' table in DB.
    So Search the 'Keywords' for matches equal to the 'Search string"
    maybe even drop certain words like 'do','how' and other words of little descriptive value.
    I suspect a lot of search engines do this sort of thing.
    I need some examples

  • #2
    Regular Coder
    Join Date
    Aug 2002
    Location
    USA
    Posts
    478
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Perhaps this may hopefully give you some ideas:

    Classic ASP Design Tips - Search For Keywords on Multiple Fields
    http://www.bullschmidt.com/devtip-se...iplefields.asp

    The above searches on each single word. And yes you could combine that with removing things like the word TO in a search string:

    strSearchString = Replace(strSearchString, " to ", " ") ...
    J. Paul Schmidt
    www.Bullschmidt.com - Freelance Web and Database Developer
    www.Bullschmidt.com/DevTip.asp - Classic ASP Design Tips


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •