[plum] Query of Query

[Dan]

Hi there Plummers,     Struggling again. Hope there’s someone out there who can re-point me in the right direction.   On my Header.cfm page I have near the top a CFmodule call for the SiteNav bar.   In the SiteNav.cfm page for the bar I run a fairly fancy SQL query to get the Nav Items from a couple of tables.  No problem here—it works very well.   A little further down the page I have a “PageBar” that will show the “CategoryName” and the “PageName” ( A Category can/will have multiple pages) Only the CategoryName(s) appear in the SiteNav bar at top. The PageNames are used in the PageBar and below that in a “subNav menu”   I need the PageBar to change values displayed as a site visitor clicks/selects CategoryName(s) from the SiteNav bar.   Since I’ve already run a query that has all the CategoryNames and PageNames, my reasoning was that all I needed to do was run a Query of Query on the “GetCategories” query that populates the SiteNav bar, by passing to it (the QoQ) the CategoryID and have my WHERE clause simply say WHERE  CategoryID = #URL.Cat#   It seems to make logical sense to me.   But I am getting an error that says my first query “GetCategories” can’t be found in memory.   Here’s some code snippets: (this is all in header.cfm)   <!-- #SiteNav  --> <cfmodule template="#request.layout#/SiteNav.cfm" pageType="#Attributes.pageType#">   …then a bit further down the page…   <!--- #PageBar ---> <div id="PageBar">             <CFinclude template="../../qry/BCC_qry_GetPageBarLabels.cfm"> <cfoutput query="GetPageBarLabels">                <span class="PageTitle">#GetPageBarLabels.PageName#</span>     GetPageBarLabels.cfm is my Query of Query on GetCategories     and over on SiteNav.cfm I have (in part)   <CFcase value="Public"> <CFset RoleCode ="Public"> <CFinclude template="../../qry/BCC_qry_GetCategories.cfm"> <cfoutput query="GetCategories"> <li><a href="" #GetCategories.CategoryName#</a></li> </cfoutput>       If you can figure out what I’m describing here, can you tell me why not the GetCategories query would not be in memory?     Thanks,         Dan Kaufman       An Elephant Never Forgets [EMAIL PROTECTED]