I'm writing CFMX using either a MSSQL or mySQL db (probably MS SQL). I've been poring over the Celko articles, but the concepts were going way over my head. Trying to develop a way to dynamically creat my array file used by the heirmenu script without using an Adjacent List Model (I'm reading that process time is much faster using the Nested Set Model).
Cutter Jochem van Dieten wrote: >Cutter (CF_Talk) wrote: > > >>I am attempting to understand some articles relating to creating Nested >>Tree Menus using the a Nested Set Model SQL db structure. The articles >>are on secretagent.com and don't really make a lick of sense to me. Has >>anyone else implented something like this who might have some sample >>code. Especially db structure and query statements (get, put, remove, etc.). >> >> > >DB structure >application and database dependent (most of all on the >SELECT/INSERT/UPDATE ratio) > >GET >http://www.intelligententerprise.com/001020/celko1_1.shtml > >PUT/REMOVE >usually done through procedures, hence database dependent. I have some >PL/pgSQL stuff for you if you want. > >Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
