Bryan
Yes I have used this structure before but it's this looping that you have to do which I was trying to avoid... Bryan Stevenson wrote: > > the setup from the hierarchical table should be something like this.. > > Parent_ID, ID, Any other fields you need > > I set Parent_ID to zero if it is the top level. All the children of the parent have >the Parent_IDs > "ID" value as their Parent_ID...so... > > Parent: > ID 1 Parent_ID 0 > Children: > ID 2 Parent_ID 1 > ID 3 Parent_ID 1 > Childs Children: > ID 4 Parent_ID 2 > ID 5 Parent_ID 2 > ID 6 Parent_ID 3 > etc. to infinity and beyond! > > but of course you're stuck with recursive queries or looping over queries etc. > > HTH > > Bryan Stevenson > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > p. 250.920.8830 > e. [EMAIL PROTECTED] > --------------------------------------------------------- > Macromedia Associate Partner > www.macromedia.com > > ----- Original Message ----- > From: "Richard Meredith-Hardy" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, January 18, 2002 10:33 AM > Subject: hierarchical database..... > > > I'm having a job getting my head around this one. > > > > Essentially I am trying to establish a hierarchical structure in a > > database in such a way one is not having to do loads of recursive > > queries to return the path between one item and another in the tree... > > is this even possible? > > > > One idea someone threw at me was XML.... well I understand WDDX, but I > > don't understand the principles of using XML as an actual database. > > Could this solve my problem? > > > > All ideas & suggestions welcome! > > > > -- > > Regards; > > > > Richard Meredith-Hardy > > ------------------------------------------------------------- > > [EMAIL PROTECTED] > > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
