1 Reply Latest reply on May 14, 2008 8:28 AM by EvolvedDSM

    Combine table 3 columns in a combo box?

    EvolvedDSM Level 2
      I need a combo box to display "lastName, firstName - phone". I have these 3 columns in my database. Can anyone provide a short cfc to xml script I could use to create an arrayCollection to use as a dataprovider for my combobox?

      I'm thinking along the lines of a CFQUERY in a cfc, then exporting the results to an xml structure and using the xml as an array collection. I just don't know how to do the cfc -> xml.

      Any alternative solutions are welcome also. thanks