Hi All
I'm building a dynamic query that will export to an Excel
spreadsheet. The client can choose from a list of fields
to export so the query is built dynamically and the column names
in the SELECT statement are built from a list submitted in
a form field. The query works fine.
Next I've got the list in a variable like so:
<cfset ColData = #Col1#,#Col2#,#Col3# etc...>
My question is this:
How can I loop over this variable in my query and print
the actual values for each column? Right now it prints
#Col1#,#Col2#,#Col3# etc...
Any takers?
Tristram Charnley
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
