2 Replies Latest reply on Sep 21, 2007 4:46 AM by EndoplasmicReticulum

    Problem with listQualify

      I have a dropdown list box on the form page that is populated with a number of units, some single words, some multiple words with spaces and some contain commas like this: AUG,ABN BCT

      I am using MS SQL Server200 and when I pass in the list to run the query I'm using listQualify in the where clause
      like this: and unit in (#listQualify(units,"'")#)

      It will not find the units that the user selected that have a comma in them.

      How can I fix this?