1 Reply Latest reply on Oct 25, 2007 8:13 PM by ntsiii

    Strange Output in ComboBox

    Mark Forsberg
      I have the following query to pull some values as well as to create a blank value. Works fine in SQL Server Query Analyzer.
      Select distinct(schedule)label
      From pickupArchive
      Select '' label
      From pickup
      order by schedule

      The results are a,b,c,d,e,f,g,h,1,2,3,4,5,6,7,8,9 and a blank

      When I use this query to populate a combobox from a call to a cfc my combobox displays a blank at the expected values of a,f, and 5 in addition to the blank that I created. I'm at a loss to figure out why this is occuring.
      Any help is appreciated.