writing row output to txt file

[JohnandSwifty]

Hi,

I need to write the rows of a query to a text file. I have two vars (header and matrix) which i concatenate into body (body being the output value). My problem is that i cant run a loop inside a cfset tag... any ideas?

thanks

 

[pigsie]

can I see some code? You can build up a variable and use cffile to write it to a file.

 

[JohnandSwifty]

Hi,

I was having trouble outputting rows (cfloop) inside a cfset tag. In the end I went for

<cfparam name="matrix" default="">
<cfoutput query="Session.NewQuoteItems">
<cfset matrix = matrix &
<!--- Rows Here --->
>
</cfoutput>