I am using the same list to store Searches, and subsearches. (QoQ's) as long as there is a list of some kind it will still work. using the other method I mentioned (0000100002...) limits the maximum number of searches the user can define.
It is a way for people to group information, and not have to define what goes into each group, but just define the group and its sub groups. if you know of any other way to achieve a similar result, i'm open to suggestions. please... :) thanks for the help Ricardo. "Steve Onnis" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Is this suposed to be a parent/child relationship? cause if it is then I dont think your going about it the right way you should be working it like this (or similar) ID Parent Item ------------------------ 1 0 Item 1 2 1 Item 2 3 1 Item 3 4 0 Item 4 5 4 Item 5 6 5 Item 6 Then your tree would look like this Item 1 -- Item 2 -- Item 3 Item 4 -- Item 5 -- -- Item 6 >From there you do a recursive routine to recurse through the tree. The way I do it, I use a custom tag (now cfc) to do this and I get it to return me a "Level" column with my query object result so I know what the indent value is for that node in the tree So my query object i get to work with would look like this ID Parent Item Level ----------------------------------- 1 0 Item 1 1 2 1 Item 2 2 3 1 Item 3 2 4 0 Item 4 1 5 4 Item 5 2 6 5 Item 6 3 Much easier to work with I recently helped Brian Gilbert get a tree structure working from a list type of structure where his levels were respresented like 1 1.1 1.1.1 1.2 1.3 1.3.1 1.3.2 in the database. Much joy was had getting that to work but he was using MSSQL. Atleast that way there is some sort of relationship with regards to levels. It looks like your just storing the parent items tree. What sort of other things are you looking at doing with the tree? Regards Steve Onnis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ricardo Russon Sent: Monday, April 05, 2004 3:37 PM To: CFAussie Mailing List Subject: [cfaussie] Re: query of list sorting MySQL 4 "Steve Onnis" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] 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 --- 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
