You lucky dog!
David Medinets has written some stored procedures to handle the nested tree
model (NTM) for you!
Proof of Concept SQL Server stored procedures at
http://medinets.onproject.com/ntm/
Now, here's my side of it:
I don't understand Steve Nelson's/Joe Celko's methodology either (or the
above SQL proceedures). From what Steve was telling me, you only make a
single SQL call to get the entire tree structure. However, I think it is
harder to write the tree data into the DB to start with (unless you have
SQL stored procedures already written for you, ha!)
I have written recursive CF tags to dig down into a traditional nested tree
table structure, so I understand those. My tags made one SQL call per tree
node.
However, if you don't want to do it Steve's way, and you want it to be
fast, I would write a stored procedure in the database to do all those
nested/recursive SQL calls on the DB side, and actually write your HTML in
the stored procedure, and dump it out as a param (one big long string).
As far as your concern about multiple users, there is no usually no issue
ADDING child nodes, since the parent already exists. So what if two users
add a record to the same parent node at the same time as long as they have
different child node ID's.
At 01:51 PM 3/15/01, Joseph Higgins wrote:
>How about if you wanted to store N trees and allow multiple people to be
>editing those trees at the same time?
>This is what I have to do this semester and am going to have to expand the
>model. Has anybody already done this?
>
>
>----- Original Message -----
>From: "BORKMAN Lee" <[EMAIL PROTECTED]>
>To: "Fusebox" <[EMAIL PROTECTED]>
>Sent: Wednesday, March 14, 2001 10:20 PM
>Subject: RE: Nested trees, what's going on?
>
>
> > Yeah, that's how I do it to, but it's well worth checking out the radical
> > new way of handling nested trees, as described in Steve Nelson's sample
> > viewlet on FuseBox.org. It's a little tricky to get your head around at
> > first, but it can really simplify and speed up your tree-handling.
> >
> > -----Original Message-----
> > From: Erik Voldengen [mailto:[EMAIL PROTECTED]]
> >
> > Recursive calls to a custom tag. That's the way to do it.
> > ....
> >
> >
> >
> > IMPORTANT NOTICE:
> > This e-mail and any attachment to it is intended only to be read or used
>by
> > the named addressee. It is confidential and may contain legally
>privileged
> > information. No confidentiality or privilege is waived or lost by any
> > mistaken transmission to you. If you receive this e-mail in error, please
> > immediately delete it from your system and notify the sender. You must
>not
> > disclose, copy or use any part of this e-mail if you are not the intended
> > recipient. The RTA is not responsible for any unauthorised alterations to
> > this e-mail or attachment to it.
> >
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
