Alpha Video Training
Results 1 to 3 of 3

Thread: Searching multiple Fields

  1. #1
    VAR
    Real Name
    Andy Meer
    Join Date
    Mar 2005
    Location
    Atherstone UK
    Posts
    452

    Default Searching multiple Fields

    Hi All,

    Happy thanksgiving weekend to those in the US.

    I have a search problem that searches multiple fields,

    I have two fields

    Condition , Also Known As

    The condition field may have
    Temporal Lobe Epilepsy

    The Also Known As may have
    TLE; Partial Epilepsy; Complex Partial Seizures; Simple Partial Seizures

    Please Note the the semi colon is in the field.

    The user may know the condition as TLE, and if he searches for TLE he will not find it because the way the search sees it is the whole of the field.

    Does anybody know of a way to break the search into its sections

    Thanks

    Andy

  2. #2
    Volunteer Moderator drgarytraub's Avatar
    Real Name
    Dr. Gary Traub
    Join Date
    May 2000
    Location
    Boca Raton, FL
    Posts
    2,780

    Default Re: Searching multiple Fields

    Andy,

    Why not just set the type of search to "contains"

    Gary

  3. #3
    VAR
    Real Name
    Andy Meer
    Join Date
    Mar 2005
    Location
    Atherstone UK
    Posts
    452

    Default Re: Searching multiple Fields

    Hi Gary


    Thanks

    Andy

Similar Threads

  1. Multiple Variable Querying Multiple Fields
    By rdecle01 in forum Alpha Five Version 7
    Replies: 18
    Last Post: 09-14-2006, 09:47 AM
  2. adding multiple values in multiple fields
    By phillip dziewior in forum Alpha Five Version 7
    Replies: 7
    Last Post: 01-23-2006, 05:01 PM
  3. format multiple fields
    By davidv43 in forum Alpha Five Version 6
    Replies: 2
    Last Post: 09-28-2005, 09:20 AM
  4. Searching multiple words in a single field
    By Chris.Tanti in forum Web Application Server v6
    Replies: 2
    Last Post: 12-13-2004, 01:46 AM
  5. adding multiple fields to one
    By Rodney Efird in forum Alpha Five Version 4
    Replies: 1
    Last Post: 06-21-2000, 12:08 PM

Bookmarks

Posting Permissions

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