Dave,

I've done  similar stuff...  granted about a year ago, so I forget the exact
method and route that I chose, but the main thing I remember was that rather
than just outputting the information, I did place it in a stuct before
anything else, and that way the module could do what it pleased....  

Also use "theID" to define if you need to display any of the child
structures... i.e if parent of child, display child kind of thing.

I'm sorry I can't help more but my db architecture is very different to
this...  any questions about what I did, then shoot!  Granted I might be off
line for a bit...  not at work yet!

Tom

-----Original Message-----
From: Dave Phipps [mailto:[EMAIL PROTECTED] 
Sent: 24 July 2003 07:25
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Revisit [ cf-dev ] Selective recurse - help!!

I always forget that!  The code is below.  If anyone can help and wants me 
send them the file off list then please let me know.

Cheers

Dave


<cfsilent>
          <cfparam name="theid" default="0">
          <cfparam name="mode" default="outline">
          <cfparam name="indent" default="0">
          <cfparam name="attributes.circuitname" default="">
          <cfif IsDefined("attributes.indent")>
                  <cfset indent = attributes.indent>
          </cfif>
          <cfif IsDefined("attributes.theid")>
                  <cfset theID = attributes.theid>
          </cfif>
          <cfif IsDefined("attributes.mode")>
                  <cfset mode = attributes.mode>
          </cfif>
          <cfparam name="attributes.showAll" default="false">
          <cfquery datasource="#request.dsn#" name="getMenus"
dbtype="ODBC">
          SELECT  circuits.circuitname, menus.menuid, menus.circuitid,
  menus.menuname, menus.parentmenuid, menus.displayorder,
contentManager.cmid
          FROM circuits, menus, contentManager, content
          WHERE   parentmenuid = #theid#
          AND content.onMenu = 1
          <cfif attributes.showAll EQ false>AND content.isApproved =
1</cfif>
          AND contentManager.contentid = content.contentid
          AND contentManager.menuid = menus.menuid
          AND circuits.circuitid = menus.circuitid
          AND circuits.circuitname = '#attributes.circuitname#'
          ORDER BY menus.displayorder, menuid, parentmenuid
          </cfquery>
</cfsilent>

<cfloop query="getMenus">
          <cfset thisid = getMenus.cmid>
          <cfoutput>
                  <span class="navbar" style="margin-left:#indent#px;">
                          <cfif attributes.cmid EQ thisid OR
  (IsDefined("caller.getFirstPage.recordcount") AND
  caller.getFirstPage.cmid EQ thisid)>
                                  <img
src="images/site_gfx/arrow_blue.gif"
  border="0" name="section#menuid#"><span
  style="color:##7C8AA2;">#menuname#</span>
                          <cfelse>
                                  <a

href="#request.self#?fuseaction=#getMenus.circuitname#.content&cmid=#cmi
d#
  " onMouseOut="MM_swapImgRestore(); self.status=''; return true;"

onMouseOver="MM_swapImage('section#menuid#','','images/site_gfx/arrow_re
d.gif',1);
  self.status='#Replace(menuname, "'", "", "ALL")#'; return true;"><img
  src="images/site_gfx/arrow_black.gif" border="0"
 > name="section#menuid#">#menuname#</a>
                          </cfif>
                  </span><br>
          </cfoutput>
          <cfquery datasource="#request.dsn#"
  cachedwithin="#CreateTimeSpan(0,0,0,2)#" name="checkForChild"
dbtype="ODBC">
                  SELECT  menuid
                  FROM menus
                  WHERE   parentmenuid = #getMenus.menuid#
          </cfquery>

          <cfif checkForChild.RecordCount gt 0>
                  <cfset nextindent = indent + 10>
                  <cfif attributes.showAll EQ true>
                          <cfset attributes.showAll = true>
                  </cfif>
                  <cf_buildtree theid = "#getMenus.menuid#" mode =
"#mode#"
  indent="#nextindent#" circuitname="#attributes.circuitname#"
  cmid="#attributes.cmid#" showAll="#attributes.showAll#">
          </cfif>
</cfloop>

At 16:04 7/23/2003 +0100, you wrote:
>Dave no attachments on the dev list --
>Repost content in the email
>
>
>
>-----Original Message-----
>From: Dave Phipps [mailto:[EMAIL PROTECTED]
>Sent: 23 July 2003 15:59
>To: ColdFusion User group
>Subject: [ cf-dev ] Revisit [ cf-dev ] Selective recurse - help!!
>
>Hi,
>
>I am still banging my head against a brick wall on this one.  I have
>attached the file buildtree.cfm.  If someone could take a look and tell
>me
>if there is any way to show/hide the output (lines 82-92) depending on
>where in the menu the user is currently located, see the url below for
>the
>display.
>
>I really need to knock this on the head otherwise I have to come up with
>a
>way of getting 2nd level menus into a dropdown system.  Why is dynamic
>navigation so hard to generate???!
>
>Cheers
>
>Dave
>
>
>
> >Hi,
> >
> >I am using a recursive tag to generate some navigation links.  The
>table
> >structure for the menus is set up in a parent/child relationship with
> >menus have a parentmenuid equal to the parent menuid or 0 if it is a
> >parent.  The recursive tag grabs the menu then checks for children then
>
> >calls itself to check if each child has any children etc.
> >
> >We have one section of the site with a large number of menus and it
>looks
> >pretty ugly.  What I want to do is only show the children of the select
>parent.
> >
> >The url to view is:
> >http://new.abingdon.org.uk/index.cfm?fuseaction=academic.content&cmid=7
>2
> >The site is not yet live but needs to be sorted asap.
> >
> >What I want to happen with the menu:  When you arrive to the Academic
> >section you should just see the top level menus (parents) then clicking
>on
> >Departments will move to another page with the departments listed.
>When a
> >specific department is clicked then the children of this department
>will
> >be seen.
> >
> >If anyone could spare a few moments to take a look and see if there is
>a
> >way to alter the tag to do the above that would be great.  Is there a
> >better way to do this navigation?
> >
> >The code for the tag is below:
> ><cfsilent>
> >         <cfparam name="theid" default="0">
> >         <cfparam name="mode" default="outline">
> >         <cfparam name="indent" default="0">
> >         <cfparam name="attributes.circuitname" default="">
> >         <cfif IsDefined("attributes.indent")>
> >                 <cfset indent = attributes.indent>
> >         </cfif>
> >         <cfif IsDefined("attributes.theid")>
> >                 <cfset theID = attributes.theid>
> >         </cfif>
> >         <cfif IsDefined("attributes.mode")>
> >                 <cfset mode = attributes.mode>
> >         </cfif>
> >         <cfparam name="attributes.showAll" default="false">
> >         <cfquery datasource="#request.dsn#" name="getMenus"
>dbtype="ODBC">
> >         SELECT  circuits.circuitname, menus.menuid, menus.circuitid,
> > menus.menuname, menus.parentmenuid, menus.displayorder,
>contentManager.cmid
> >         FROM circuits, menus, contentManager, content
> >         WHERE   parentmenuid = #theid#
> >         AND content.onMenu = 1
> >         <cfif attributes.showAll EQ false>AND content.isApproved =
>1</cfif>
> >         AND contentManager.contentid = content.contentid
> >         AND contentManager.menuid = menus.menuid
> >         AND circuits.circuitid = menus.circuitid
> >         AND circuits.circuitname = '#attributes.circuitname#'
> >         ORDER BY menus.displayorder, menuid, parentmenuid
> >         </cfquery>
> ></cfsilent>
> >
> ><cfloop query="getMenus">
> >         <cfset thisid = getMenus.cmid>
> >         <cfoutput>
> >                 <span class="navbar" style="margin-left:#indent#px;">
> >                         <cfif attributes.cmid EQ thisid OR
> > (IsDefined("caller.getFirstPage.recordcount") AND
> > caller.getFirstPage.cmid EQ thisid)>
> >                                 <img
>src="images/site_gfx/arrow_blue.gif"
> > border="0" name="section#menuid#"><span
> > style="color:##7C8AA2;">#menuname#</span>
> >                         <cfelse>
> >                                 <a
> >
>href="#request.self#?fuseaction=#getMenus.circuitname#.content&cmid=#cmi
>d#
> > " onMouseOut="MM_swapImgRestore(); self.status=''; return true;"
> >
>onMouseOver="MM_swapImage('section#menuid#','','images/site_gfx/arrow_re
>d.gif',1);
> > self.status='#Replace(menuname, "'", "", "ALL")#'; return true;"><img
> > src="images/site_gfx/arrow_black.gif" border="0"
> > name="section#menuid#">#menuname#</a>
> >                         </cfif>
> >                 </span><br>
> >         </cfoutput>
> >         <cfquery datasource="#request.dsn#"
> > cachedwithin="#CreateTimeSpan(0,0,0,2)#" name="checkForChild"
>dbtype="ODBC">
> >                 SELECT  menuid
> >                 FROM menus
> >                 WHERE   parentmenuid = #getMenus.menuid#
> >         </cfquery>
> >
> >         <cfif checkForChild.RecordCount gt 0>
> >                 <cfset nextindent = indent + 10>
> >                 <cfif attributes.showAll EQ true>
> >                         <cfset attributes.showAll = true>
> >                 </cfif>
> >                 <cf_buildtree theid = "#getMenus.menuid#" mode =
>"#mode#"
> > indent="#nextindent#" circuitname="#attributes.circuitname#"
> > cmid="#attributes.cmid#" showAll="#attributes.showAll#">
> >         </cfif>
> ></cfloop>
> >
> >
> >--
> >** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
> >
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >For human help, e-mail: [EMAIL PROTECTED]
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.502 / Virus Database: 300 - Release Date: 18/07/2003
>
>
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.502 / Virus Database: 300 - Release Date: 18/07/2003
>
>
>
>--
>** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
>
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>For human help, e-mail: [EMAIL PROTECTED]


-- 
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]


--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]

Reply via email to