Dynamic variable names??? Please Help!

[Yavka]

So I'm making this application for accessing research data - lots of different
data tables, each with it's own data columns.

I have made the interface where the user can pick which data columns to
download. This produces a list of table columns to be fetched by the database -
I pass this on to the SQL query, and get back the result. But how do I output
that, without hard-coding the names of the data columns?

<cfoutput query="qData">
#qData.col1#,#qData.col2#,#qData.col3#
</cfoutput>

The above would be fine, but I don't know which of the many columns have been
selected - they are stored in the list variable, and also in qData.ColumnList,
but I can't figure out how to use the list contents to tell cfoutput what to
output. Is there a way to make it output all the columns in a query, withouit
specifying their names?

Thanks,

y

[mxstu]

<cfoutput query="qData">
<cfloop list="#qData.columnList#" index="col">
#qData[col][currentRow]#
</cfloop><br>
</cfoutput>

[Yavka]

Yes, this works. Thanks a bunch!

I see now how it works - it's so simple, I would have never thought of it! I
wish they had stuff like this clearly explained in the documentation. Or could
you recommend a good book?

:-) :-) :-)

[mxstu]

Yes, it would be nice but I guess it is hard to document *every* usage of every available feature! I'm not that up on the recent books but you might want to search the forums for recommendations.