They provide a service (which you must pay for) that
unlocks lots of tutorials, but some are available for free.
The one you're looking for is "nested trees", and can be
found by clicking "You still have time to learn" > "Free
online training" > "Nested trees"
Good luck!
Norman
Quoting Michael Lugassy <[EMAIL PROTECTED]>:
> I didn't find secretagents' tutorial,
> the site looks alot like hotmail, I can't get in
> without becoming
> a member, or what? :)
>
> I would like to take a look at it before implement
> the alternative.
>
> Michael.
>
> ----- Original Message -----
> From: "Norman Elton" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, July 23, 2001 8:07 PM
> Subject: Re: Me Vs. Complexed Table Design
>
>
> > Sounds like you're trying to implement a tree
> (it's formal
> > name). For a good lesson, check out Steve Nelson's
> free
> > tutorial at www.secretagents.com. The concepts
> somewhat
> > complicated, so you might have to read it a few
> times, but
> > works well.
> >
> > As an alternative, you could just keep track of
> the
> > following for each record:
> >
> > 1. ID
> > 2. Name
> > 3. Parent ID
> >
> > Where Parent ID is the parent of the current
> record. This
> > makes it hard to build a link from a record (known
> as a
> > node) back to the root of the tree. You'd probably
> have to
> > loop over a CFQUERY, which gets nasty.
> >
> > Hope this helps
> >
> > Norman
> >
> > Quoting Michael Lugassy <[EMAIL PROTECTED]>:
> >
> > > We have a big index of sites, each site belongs
> to a
> > > certain "main category"
> > > and a sub_category.
> > >
> > > Certain sites are nested inside 2,3 and even 5
> > > sub-sub categories.
> > >
> > > How can I create a category(ies) table(s) that
> will
> > > store the catID and catNAME?
> > > (each category/subcategory ID takes 2 places
> xx)
> > >
> > > Here is an Example:
> > >
> > > The Yahoo! site, for example is in:
> > >
> > > Computers and Internet > Internet > Internet
> and
> > > Search Engines > Directories > World
> > >
> > > Where Computers and Internet = 24 00 00 00 00
> > > (I've added space just to explain what I need)
> > > Internet = 24 11 00 00 00
> > > Internet and Search Engines = 24 11 92 00 00
> 00
> > > Directories = 24 11 92 83 00 00
> > > World = 24 11 92 83 00
> > >
> > > Ofcourse there could be more then one sub-sub
> > > category named "world"
> > > and the sub-sub count varies.
> > >
> > > Any help, tips, something?
> > >
> > > Michael.
> > >
> > >
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
