2 Replies Latest reply on May 4, 2007 10:37 AM by mikey999

    (#ListQualify(MyMultiPickValue, "'")#)

    mikey999 Level 1
      I am trying to search a field based on a multi pick drop down search search. This works really well when the has the exact value in it. But is there a why yo do this while adding wild cards on.

      For example this search

      <CFQUERY Name="GetData" datasource="MyDataSource">
      SELECT *
      FROM Tagging
      WHERE Tagging.TagName IN (#ListQualify(MyMultiPickValue, "'")#)
      </CFQUERY>

      may look like

      SELECT *
      FROM Tagging
      WHERE Tagging.TagName IN (african,american)#)

      it will pull up all records with africa and american but not records with like south american or souch africa

      in a normal query you can fix this by adding %

      like

      AND Tagging.TagName LIKE '%#MyMultiPickValue#%'

      is there any way to put a while card of the search value for this query ?

      <CFQUERY Name="GetData" datasource="MyDataSource">
      SELECT *
      FROM Tagging
      WHERE Tagging.TagName IN (#ListQualify(MyMultiPickValue, "'")#)
      </CFQUERY>


      thanks for your help in this matter
      m