Hello Guys,
Thanks for getting back to me on this one, it was a late night last night
and I think I was starting to go mad :-D Let me try and explain a little
about my current attempt, as horrible as it may be.
<cfquery name="LOCAL.MyQuery"
datasource="#VARIABLES.Instance.Datasource.getSource()#">
SELECT Article_ID,
Parent_ID,
Article_Name
FROM Article
ORDER BY Parent_ID,
Article_Name,
Article_ID
</cfquery>
Then for my output I was doing something like this:
<cfoutput query="VARIABLES.qMenu" group="Parent_ID">
<li>
#VARIABLES.qMenu.Article_Name#
<ul>
<cfoutput>
<li>#VARIABLES.qMenu.Article_Name#</li>
</cfoutput>
</ul>
</li>
</cfoutput>
Thanks for any further advice you can give guys, its greatly appreciated.
Rob
-----Original Message-----
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: 13 August 2007 03:38
To: CF-Talk
Subject: Re: Dynamic Menu
http://www.oreilly.com/catalog/sqlpr/chapter/ch01.pdf
On 8/13/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.
--
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:286058
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
