1 Reply Latest reply on Dec 19, 2006 3:00 PM by Dan Bracuk

    values in pick list

    TESS_GEAR Level 1
      <cfquery name="getValue" datasource="testdata">
      select c.colorname, r.relatedcolor, o.relatedobject
      from Color.c INNER JOIN SimilarColor s
      ON c.colored = s.index_id
      INNER JOIN ObjectColor o
      ON s.objected = o.index_id
      </cfquery>

      Color Description:
      <select id="ColorDescript" name="ColorDescript">
      <cfoutput query="getValue">
      <cfset variables.SDNF = "#getValue.colorname##getValue.relatedcolor##getValue.relatedobject#">
      <option value="#getValue.SDNF#">#variables.SDNF#
      </cfoutput>
      </select>

      if i run the code, the list of color description shows duplicated records.
      such as

      RedOrangeTabe
      RedOrangeTabe
      RedOrangeTabe
      RedOrangeTabe
      BlueGreenChair
      BlueGreenChair
      PurpleGreenKeyboard
      PurpleGreenKeyboard
      PurpleGreenKeyboard
      PinkYellowCap
      PinkYellowCap
      PinkYellowCap

      Is there any way i can list one value instead of duplicated values in the pick list?

      expected list is as below:

      RedOrangeTabe
      BlueGreenChair
      PurpleGreenKeyboard
      PinkYellowCap