I have a very simple select query: SELECT ID, parentID, title, body, createdate, updatedate, status, hierarchy FROM tblPages WHERE (status = 'A') ORDER BY ID
It works fine except for one thing. The ID is not necessarily the way to order it. If the page has a parent(s), then that parent ID is put in the parentID field, and the hierarchy field has the hierarchy of the site for both navigation and the breadcrumb list. So what is happening is, if I have a child page and it is about five records below the parent page, then the child displays five records below the parent. I tried ordering by the hierarchy field, but since that is a text field, it does not order correctly either. So any ideas how I can do this? Or should I do the ordering/grouping in the CF code? Thanks, -- Bruce ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2899 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
