I'm not sure I understand you, but eitherway it sounds over-complicated. Is there a reason you can't simply create a numerical field to use for ordering, and update the values of that to get things in the right position?
On 8/6/07, Bruce Sorge <[EMAIL PROTECTED]> wrote: > > 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 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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/SQL/message.cfm/messageid:2900 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
