Multiple keyword search

Results 1 to 2 of 2

Thread: Multiple keyword search

  1. #1
    Join Date
    Dec 1969

    Default Multiple keyword search

    Hi there :) <BR><BR>With my limited knowledge, I&#039;ve managed to create a simple search page using ASP (within Ultradev) and an Access database. At present though I can only search with a single keyword. How do I modify the script so that multiple keywords can be searched for?<BR><BR>Thanks for your help!

  2. #2
    Join Date
    Dec 1969

    Default RE: Multiple keyword search

    You can use OR & AND in your criteria. Without seeing your Sql I can&#039;t offer much more help, but here is a rough way to do an exact match on 2 values.<BR><BR>Select * from MyTable where MyField = &#039;" & Keyword1 & "&#039; OR MyField = &#039;" & Keyword2 & "&#039;"<BR><BR>

Posting Permissions

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