cfoutput and cfloop

[raulriera]

Hi all, well this is my question:

I want to show 2 or more different sets of record sets but one or more of them
have to be nested on the first, since I cant do

<cfoutput query="query1">
<cfoutput query="query2"> </cfoutput>
</cfoutput>

I tried replacing the second cfoutput with cfloop

<cfoutput query="query1">
<cfloop query="query2"> </cfloop>
</cfoutput>

Now this works fine for outputting the data in the second query but for some
reason the data in the first nested inside the second query wont update
(example)

<cfoutput query="query1">
<cfoutput query="query2">
#query1.id# #query2.name#
</cfoutput>
</cfoutput>

I will always get the first query id in that output and not the "current"
one.. why is this happening?? hope I made myself clear hehe seems like a lot of
examples

[The ScareCrow]

When looping through 2 queries, the outer query seems to be lost (for the
values of that row)

<cfoutput query="query1">
<cfset query1ID = query1.id>
<cfloop query="query2">
#query1ID# #query2.name#
</cfloop>
</cfoutput>

This should do it.

Ken

[vkunirs]

Hi

I think it is having some problem(bug).
even i faced similar problem.

See this code :

<cfquery name="parttype" datasource="party">
select * from parttype
</cfquery>
<cfoutput query="parttype">
<cfquery name="parts" datasource="party">
select * from parts where partTypeID=#parttype.partTypeID#
</cfquery>
<cfloop query="parts">
#parttype.parttype#&nbsp;&nbsp;#name#
</cfloop>
#parttype.partTypeID#,#parttype#<br>
</cfoutput>

in the cfloop when i display #parttype.parttype# i am getting it as 1 only.
means the first id.
but after the cfloop i will get the correct #parttype.parttype# value.

[vkunirs]

Hi Ken

that way we can do easily but we need store that field value into another varaible and we need to use that variable in the loop
that is i am doing till now.

k any how many thanks.

[raulriera]

Thank you all guys, I guess it is a bug since its something so simple :S storing the data in a variable worked fine.

Thanks again