I am wondering if this is possible?
I would like to query a db:
FROM this table
color car age
blue family 1
green sport 2
red van 3
I want to output the results of the query as:
<cfset string="[blue,family,1] , [green,sport,2] , [red.van,3]">
is this possible?
I have tried many ways, all are either outputting only a single row, or trying to use ValueList() i am returning :
[blue,red,green] [family, sport,van] [1,2,3]...