RE: [plum] Query of Query

Scott Krebs Thu, 05 May 2005 17:12:54 -0400

Greetings Dan,

Since you run the first query in a template called by cfmodule and not cfinclude, the result set is out of the scope of the rest of the page. A quick fix would be to load the result set into the session scope by doing something like the following in SiteNav.cfm after the cfquery:

You can then do your QoQ on the query "session.GetCategories" and it should work just fine.

That's nowhere near an elegant solution, but it'll work...

HTH!

Scott

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan
Sent: Thursday, May 05, 2005 4:52 PM
To: [email protected]
Subject: [plum] Query of Query

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)

…then a bit further down the page…

<span class="PageTitle">#GetPageBarLabels.PageName#</span>

GetPageBarLabels.cfm is my Query of Query on GetCategories

and over on SiteNav.cfm I have (in part)

</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]

--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.5 - Release Date: 5/4/2005

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.5 - Release Date: 5/4/2005

RE: [plum] Query of Query

Reply via email to