• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

Structuring a Dropdown Menu with 14 nested levels

I am trying to build a dropdown menu with 14+ levels in coldfusion. I was directed here for an answer. Below was the response from the expert in the coldfusion section:

"14 nested levels? Then you're asking about a db query not CF. For MS SQL, the answer
probably involves CTE's.  If you ask in the MS SQL zone, I'm someone there
could answer it."

Help plz
  • 2
2 Solutions
Raja Jegan RSQL Server DBA & ArchitectCommented:
If you want to get recursive values till 14 levels, then the sample code present under "D. Using a recursive common table expression to display two levels of recursion" in the below link might help:


Just change WHERE EmployeeLevel <= 2  to 14 to get nested values till 14 levels.
timbad2021Author Commented:
Found the answer:
timbad2021Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now