CFFILE output multiple rows from a query

[robstacey]

I have a quiestion about the below. I am working with this method, but I find
that my code results in the first record being outputed twice in the document.
How can I resolve that? And I can not just leave a blank line at the top (that
will screw things up further into what I am doing).

My code is attached:

<cffile action="WRITE" file="#adrdir#\sfiles.dat" output="#Dirlist.Name#">
<cfloop query="Dirlist">
<cffile action="APPEND" file="#adrDir#\sfiles.dat" output="#Dirlist.Name#">
</cfloop>

[Stressed_Simon]

Try this!

<cfset FileData = "">

<cfloop query="Dirlist">
<cfset FileData = FileData & Dirlist.Name>
</cfloop>

<cffile action="WRITE" file="#dir#\filenamet" output="#FileData#">

[robstacey]

Using this code resulted in only the last record being written to the file.

Anything else?

[Stressed_Simon]

OK VERY weird?????? Have you tried outputting the variable before the cffile to see if it has added all the data. Also cfdump the query to make sure it has what you think it does in it!

[efecto747]

try adding a carriage return to the loop stressed_simon suggested:



<cfloop query="Dirlist">
<cfset FileData = FileData & Dirlist.Name & Chr(13)>
</cfloop>

[robstacey]

Thank to everyone for your help. The resolution was:

<cfset FileData = "">
<cfloop query="query">
<cfset FileData = FileData & query.var & #Chr(13)#&#Chr(10)#>
</cfloop>

<cffile action="WRITE" file="dir\filename" output="#FileData#">