Create text file from query

[Efused]

I wantto create a simple text file from the requlsts of a query, but I can't
seem to escape thequotes right.

I am trying to run...

<cfset ScrollerXML ="
<cfoutput query='GetRates'>
<country pkey="#CountryID#" scroller="#OnScroller#"
rate="#CountryRate1#">#CountryName#</country>#chr(10)#
</cfoutput>
">

To give me a file that looks like:

<country pkey="1" scroller="1" rate=".50">USA</country>
<country pkey="2" scroller="0" rate=".75">GB</country>
<country pkey="3" scroller="1" rate="1.50">USSR</country>

how do I run that query insdie the <cfset> tag?

[SafariTECH]

try using CHR(34) instead fo the quotes in the actual output

I also don't think running a loop inside a variable assignment will properly
work.

Try creating the variable and concatenating within the loop rather than the
opposite.

... then when done save the final variable result to a file using CFFILE

<cfset txtdata = "">

<cfoutput query='GetRates'>
<cfset txtdata="#txtdata#<country pkey=#CHR(34)##CountryID##CHR(34)#
scroller=#CHR(34)##OnScroller##CHR(34)#
rate=#CHR(34)##CountryRate1##CHR(34)#>#CountryName #</country>#chr(10)#">
</cfoutput>