It would be helpful to see the query so we can see where you are going wrong.
On 8/12/07, Robert Rawlins - Think Blue <[EMAIL PROTECTED]> wrote: > Hello Chaps, > > > > I've done this kind of thing before, but for some reason I'm struggling to > remember quite how I did it. I'm building a dynamic menu system from a > database table. The table contains all the pages for the site within it, and > it's a self relating table which uses a 'parent_id' column to define which > parent each page belongs too. > > > > If the page does not have a parent, then the parent_id is set to 0 and these > should effectively be on the top level of the menu system. In proper css > fashion the plan is to have the menu as an un-ordered list, which should > look something like this: > > > > <ul> > > <li>Top Level Item</li> > > <li>Top Level Item 2 > > <ul> > > <li>Child of item 2</li> > > <li>Child of item 2</li> > > <li>Child of item 2</li> > > <li>Child of item 2</li> > > </ul> > > <li> > > <li>Top Level Item 3 > > <ul> > > <li>Child of item 3</li> > > <li>Child of item 3/li> > > </ul> > > </li> > > > > </ul> > > > > However I'm struggling to get the 'groupby' clause quite right on the > outputs, can anyone offer any advice on this? I want all items with > parent_id as 0 on that top level, and then there corresponding children > displayed in the nested lists. > > > > Thanks for any help you guys can offer. > > > > Rob > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286049 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
