This content has been marked as final. Show 4 replies
Even though you already have something in mind to use, you might try looking at commercial packages that have dynamic database population capabilities built-in. We have tried a few different ones (Milonic and others) but one I like is:
This is only a personal opinion btw, I am not connected to the product in any way. You can download and try for free but must buy for commercial usage. Take a look at the Coldfusion samples.
There are many others available as well. You can find these by searching for dhtml menu systems. Some charge per site usage - the one above you can use with an unlimited number of sites for a single price.
scooter5791: thanks for the advice! I've downloaded the trial version of the SoThink product and really like it. The only thing I'm struggling with now is writing the query to dynamically populate my submenus -- parent menus are working fine, but can't seem to figure out how to loop through a query to pull the children for each parent. Brain freeze, I guess -- thoughts?
Your best bet is probably a carefully formatted initial query and some elegant CF coding. Barring that, you could always do the brute force way and pull everything back for all parents in an initial query and then perform a CF Query of a Query for each parent to retrieve the appropriate data.
Thanks, Michael. The Sothink product scooter5791 recommended actually made this pretty easy. Parent query works just as
ORDER BY topNavOrder
Child query is simply
WHERE topNavParentId <> 0
and then the output just loops through the GetTopNavDropdown query, basically:
The Sothink product does all of the formatting etc.
Thanks, everyone, for the help. --Dbast