that's correct I don't want to output to the client, but
create a file
the data looks fine when I open it in a text editor
This is what Im using
<CFFILE ACTION="Append" FILE="#csvfile#"
OUTPUT="lead_uid,lead_fn,lead_ln,lead_email,lead_phone,lead_phone_full,lead_date,lead_aff1,lead_aff2,lead_aff3"
ADDNEWLINE="yes">
<CFLOOP QUERY="GetData"><CFFILE ACTION="Append"
FILE="#csvfile#" OUTPUT="#Getdata.lead_uid#,#replacenocase
(GetData.lead_fn,",","
","ALL")#,#replacenocase(GetData.lead_ln,",","
","ALL")#,#replacenocase(GetData.lead_email,",","
","ALL")#,#replacenocase(GetData.lead_phone,",","
","ALL")#,01144#right(replacenocase(GetData.lead_phone,",","
","ALL"),
(len(replacenocase(GetData.lead_phone,",","
","ALL"))-1))#,#createODBCDATETIME(GetData.lead_date)#,#replacenocase
(GetData.lead_aff1,",","
","ALL")#,#replacenocase(GetData.lead_aff2,",","
","ALL")#,#replacenocase(GetData.lead_aff3,",","
","ALL")#"></CFLOOP>
... View more