address variable that holds more than one fields to downloadable CSV excel file

[silviasalsa]

Hello I have this code that converts a regular document to a downloadable CSV excel file
And it works great:
<cfcase value="CSV">
<CFHEADER NAME="Content-Disposition" VALUE="attachment; filename=Property.csv">
<cfcontent type="application/csv">"CalNUM","PEENUM”
<cfloop query="getGPAZCCases"><cfoutput>"#ltrim(CalNUM)#","#PEENUM#"

.
My goal is to add the address field that composes of these fields below:

#ST_no#
#ST_DIR#
#ST_Name#
#st_suffix#"
so I added this like the code below.


<cfcase value="CSV">
<CFHEADER NAME="Content-Disposition" VALUE="attachment; filename=Property.csv">
<cfcontent type="application/csv">"CalNUM","PEENUM”
<cfloop query="getGPAZCCases"><cfoutput>"#ltrim(CalNUM)#","#PEENUM#"


Unfortanetly it has not worked out.

If I do have a CFSET to declare a variable to hold the address field like so:
<CFSET address=(" #ST_no# ", " # ST_DIR# ", "# ST_Name # ", " # st_suffix #
")">
Where do I put it in the existing codei have below?
Thanks in advance.


<cfcase value="CSV">
<CFHEADER NAME="Content-Disposition" VALUE="attachment; filename=Property.csv">
<cfcontent type="application/csv">"CalNUM","PEENUM”
<cfloop query="getGPAZCCases"><cfoutput>"#ltrim(CalNUM)#","#PEENUM#"

[cf_dev2 · Accepted solution]

> so I added this like the code below.

It doesn't look any different than the code posted above it.

a) Try adding the name of the new column:

"CalNUM","PEENUM", "ADDRESS"

b) Then add the four fields enclosed in one set of quotes

"#ltrim(CalNUM)#","#PEENUM#", "#ST_no# #ST_DIR# #ST_Name# #st_suffix#"

[silviasalsa]

cf_dev2

IT WORKS GREAT!

Thanks for your Help