3 Replies Latest reply on Nov 16, 2006 12:22 PM by Newsgroup_User

    cfsearch and "&"


      I have a verity collection that contains product descriptions. I have a cfsearch script that searches that collection. It works very well most of the time. However, when I try to search for items with an "&" in the description using a search term with an "&", it produces no results. This is scenario I am particularly referring to:

      Product in verity collection: T&S 5HR-343-01 50' Hose Reel w/ Spray Valve
      Search Term: T&S
      CFSEARCH criteria: <WILDCARD>T&S* OR <STEM>T&S

      Does anyone know if & is ignored in CFSEARCH? Or possibly see something else I am doing incorrectly?