I would sugest that valueList() is the wrong option for what you are attempting to do. It looks like a clasic use case for the group property of the <cfoutput...> tag.
<cfquery name="qFruits"> SELECT number, fruits FROM table WHERE (fruits = 'apple') GROUP BY number, fruits ORDER BY fruits </cfquery> <table <tbody> <cfoutput query="qFruits" group="fruits"> <tr> <td><cfoutput>#qFruits.number#,</cfoutput></td> <td>#qFruits.fruits#</td> </tr> </cfoutput> </tbody> </table>
I leave it up to you and the documentation to figure out how to eliminate the extra comma this simple example will produce.
Another way is to select a concatonation of the two fields, plus a comma in the query. This will probably include converting the number to a string. The details depend on the db.
My example uses the group tag in the cfoutput. Thanks however. I looked at my problem again and determined that I did not need to output my columns like that and tried a completely different method. Thanks for assisting however.