>> (I am creating a cheesy overly simple for my own use only CMS). Probably ORDER BY parentID, ID
should do it. All pages at the same level should be kept together, starting with level 0 which should have parentID = 0 or NULL If it is a hierarchical tree system, you should be able to order pages in each level, so you need some "order" field. The query would then be ORDER BY parentID, order -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2903 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
