cffile write

[Cwinters]

Hi all,

I am trying to output to a txt file using cffile write.

Problem is I output a query with a header and run a subquery inside of each
header output to output a series of line items. Ex:

cfoutput query="query1"
#a#, #b#
cfquery name="query2" datasource="abc"
select * from a
/cfquery
cfloop query="query2"
#c#,#d#
/cfloop
/cfoutput

It cant find any of the fields in the second query...any ideas?

[shp.jc]

Have you tried scoping the variables?

query1.a, query1.b

query2.c, query2.d

I'm assuming your putting the code into <cfsavecontent>

[Cwinters]

I did scope the variables...claims that the variable query2.d is undefined still.