Perplexed and Confused with CSV conversion from Query

[Tomdogggg]

I'm having a little trouble converting a query object into a CSV file.
Everyplace I've ever seen it done, makes a loop and assumes that the COLUMN
NAMES will always be the same. The column names in the query objects that I
want to convert to a CSV file are NOT always the same. Is there a way that I
can loop through the QUERY.ColumnList property and insert POUNDSIGNS around
each word which can be utilized as a dynamic statement later-on in my code?

[mxstu]

Everyplace I've ever seen it done, makes a loop and assumes that the COLUMN
NAMES will always be the same.

What do you mean by "assumes ...the column names will always be the same"?
What are you trying to do exactly?

[Tomdogggg]

Ok, let's say I'm making a QUERY object into a comma-separated-text(we'll
assume the query is called 'myQuery'):

<cffile action="write"
nameconflict="overwrite"
file="file.csv'"
output="#myQuery.ColumnList#">
<cfloop query="myQuery">
<cffile action="append"
file="file.csv"
output="#column1#, #column2#, #column3#, etc...">
</cfloop>

The problem I'm having, stems from the fact that the columns going into the
comma-separated-text, are assumed to be column1, column2, and column3: What if
this wasn't the case, what if there was NO column1? It would throw an error,
and not make the file correctly. I need to have a dynamically created list of
ALL of the columns in the query so that I can replace the partially dynamic,
but not TOTALLY dynamic statement of 'output="#column1#, #column2#, #column3#,
etc...">' into a comma separated list of the COLUMN NAMES with POUNDSIGNS
around each name.

[BSterner]

Something along the lines of...



<cfset filepath = "#GetDirectoryFromPath(ExpandPath("*.*"))#\file.cs v">
<cfset columns = qEmployees.ColumnList>

<cffile action="write"
nameconflict="overwrite"
file="#filepath#"
output="#columns#">

<cfoutput query="qEmployees">
<cfset record = "">
<cfloop list="#columns#" delimiters="," index="colName">
<cfset colVal = qEmployees[VARIABLES.colName]>
#colName#=#colVal#,
<cfset record = record & "#colVal#,">
</cfloop>
<cffile action="append"
file="#filepath#"
output="#record#">
</cfoutput>

[Tomdogggg]

Chr(35) Nice job.

[BSterner]

Actually, double pound signs would work too and be a better approach.

<cfset record = record & "###colName###=#colVal#,">