Whjat database you using for this? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ricardo Russon Sent: Monday, April 05, 2004 2:59 PM To: CFAussie Mailing List Subject: [cfaussie] query of list sorting
Hi guys. my query returns a set of lists. which I need so sort. ROW | Record | Name 1 | | Show All 2 | 1 | Industry 3 | 1 | Country 4 | 1,2 | Security 5 | 1,3 | Europe 6 | 1,3,5 | Germany 7 | 1,3,5,6 | Berlin 8 | 1,2,4 | Alarms 9 | 1,2,4 | Glass I need to sort them into a tree structure, by their depth and alphabetically Show All -Country --Europe ---England ----London -Industry --Security ---Alarms ---Glass Normally I would use an alphabetically sorted id list 00001 0000100001 000010000100001 0000100002 .... but I need to process the lists in other ways aswell. Any Ideas? TIA Ricardo. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
