Ah ok, I think I see what your problem is.
I don't think you cal get article ordered properly this way, with just
one query.
I've developped the same sort of menu, and I use a recursive template to
build it.
Every call to the template will build a submenu under such parent_ID
Here is the fist call from the main page:
<CFMODULE TEMPLATE="menuBuild.cfm" PARENT="0">
Then in menuBuild.cfm (non essential removed, and change variable names
for you environment):
<CFSETTING ENABLECFOUTPUTONLY="yes">
<CFQUERY NAME="getMenuItems" DATASOURCE="#application.applicationName#">
SELECT *
FROM menuItems
WHERE parentItem = #attributes.parent#
ORDER BY rank
</CFQUERY>
<CFIF getMenuItems.recordCount NEQ 0>
<CFOUTPUT><UL></CFOUTPUT>
<CFOUTPUT QUERY="getMenuItems">
<LI>#textItem#
<CFMODULE TEMPLATE="menuBuild.cfm" PARENT="#itemId#"></LI>
</CFOUTPUT>
<CFOUTPUT></UL></CFOUTPUT>
</CFIF>
<CFSETTING ENABLECFOUTPUTONLY="no">
--
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286068
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
