Yeah, I see what you are talking about. I think that I need to look at redoing this table for sure. This was my first stab at a CMS and I am discovering some issues with it. This band-aid solution will work for the interim though.
Thanks, Bruce -----Original Message----- From: Dale Fraser [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 5:01 PM To: CF-Talk Subject: RE: Query Question You can't really. Your DB is badly designed if you have one field called hierarchy that contains multiple elements. Its not normalised. Normally the hierarchy would be in a different table. But if you want to persist with this and you can change the hierarchy field you would need to store it like. 001 001~007 001~008 001~009 001~010 001~012 001~012~013 001~012~014 Then when sorting this string, it will come out as you expect. I'm assuming you wouldn't have more than 999 items, but if you do, then you need to pad with more 0's. Regards Dale Fraser http://learncf.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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/CF-Talk/message.cfm/messageid:290894 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
