Hi, I can get this to work and have no idea why. The nested loop always seems to read get_costumecat.CostumeCategoryID as the same even though the main loop knows that its changing on each pass.
Please Help!!!
<cfquery name="get_costumecat" datasource="#DATASOURCE#">
SELECT * FROM CostumeCategory
</cfquery>
<cfquery name="get_costumes" datasource="#DATASOURCE#">
SELECT * FROM Costume
</cfquery>
<cfloop query="get_costumecat">
<font size="4"><strong><cfoutput>#CostumeCategoryName#</cfoutput> <cfoutput>#CostumeCategoryID#</cfoutput></strong></font><br>
<cfloop query="get_costumes">
<cfif get_costumecat.CostumeCategoryID EQ get_costumes.CostumeCategory>
<cfoutput>#CostumeName#</cfoutput><BR>
</cfif>
</cfloop>
</cfloop>
Please Help!!!
<cfquery name="get_costumecat" datasource="#DATASOURCE#">
SELECT * FROM CostumeCategory
</cfquery>
<cfquery name="get_costumes" datasource="#DATASOURCE#">
SELECT * FROM Costume
</cfquery>
<cfloop query="get_costumecat">
<font size="4"><strong><cfoutput>#CostumeCategoryName#</cfoutput> <cfoutput>#CostumeCategoryID#</cfoutput></strong></font><br>
<cfloop query="get_costumes">
<cfif get_costumecat.CostumeCategoryID EQ get_costumes.CostumeCategory>
<cfoutput>#CostumeName#</cfoutput><BR>
</cfif>
</cfloop>
</cfloop>