SELECT *, LEVEL
FROM NAVMENU
START WITH MNUPARENT = 0
CONNECT BY PRIOR MNUPARENT=MNUCHILD
<cfoutput query="qMenu"...>
#RepeatString("- ",qMenu.level)# #qMenu.MNUDISP#<br>
</cfoutput>
This is simple, but you can do more complicated things by using level
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: vrijdag 7 mei 2004 0:45
> To: CF-Talk
> Subject: grouping output
>
> I'm wanting to dynamically create a menu.
> My table has 6 columns.
> MNUITEMNUM (primary key - increments on insert), MNUPARENT
> (the parent menu id), MNUCHILD (the child menu id), MNUURL
> (the link associated with the menu item), MNUDISP (what's
> displayed as the menu item), MNUWIN (determines whether to
> open in new or same window)
>
> So here's a sample menu...
> MNUITEMNUM MNUPARENT MNUCHILD MNUURL
> MNUDISP MNUWIN
> 21 1 0
> _javascript_:; Equipment
> 22 21 1
> Assets/Documents/handset_matrix.xls Handset
> Profiles new
> 23 22 1
> index.cfm?template=htm Handset
> Training Materials same
> 24 103 1
> _javascript_:; Rebates
> 25 21 103
> Assets/Documents/T720 Rebate spiff 4-1-04.c2.doc Current
> Rebates new
> 26 22 103
> Assets/Documents/T720 rebate procedures.doc Rebate
> Procedures new
> 27 23 103
> mailto:[EMAIL PROTECTED] Rebate Support
> 28 25 1
> Assets/Documents/roam_indicators.doc Roam
> Indicators new
>
>
> This creates a menu that looks like
> Equipment > Handset Profiles
> Handset Training Materials
> Rebates > Current Rebates
> Rebate Procedures
> Rebate Support
> Roam Indicators
>
>
> now I can get this to output with SQL..
> SELECT *
> FROM NAVMENU
> START WITH MNUPARENT = 0
> CONNECT BY PRIOR MNUPARENT=MNUCHILD
>
> But I want to output this using Cold Fusion to show a visual
> of the menu..
> I've tried using group and output but I'm coming up with nothing..
> Maybe see something like I demonstrated above...
> IE
> Equipment
> -Handset Profiles
> -Handset Training Materials
> -Rebates
> --Current Rebates
> --Rebate Procedures
> --Rebate Support
> -Roam Indicators
>
> How can this be done?
>
>
>
>
> **************************************************************
> ****************************
> The information contained in this message, including
> attachments, may contain privileged or confidential
> information that is intended to be delivered only to the
> person identified above. If you are not the intended
> recipient, or the person responsible for delivering this
> message to the intended recipient, ALLTEL requests that you
> immediately notify the sender and asks that you do not read
> the message or its attachments, and that you delete them
> without copying or sending them to anyone else.
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
