We have stored procedures to manipualte all aspects
of our NTM trees.
I have sucessfully implemented NTM trees. Our stored
procedures were based on excellent stored procedures
written by Dave Medinets, with a little help from
Dan Switzer ;)
You can also check out SQL For Smarties by Joe Celko
which details the NTM so that you could easily create
your own stored procedures.
Mail me off-list if you want the stored procedures.
Thanks
Jeremy Allen
elliptIQ Inc.
--
http://www.neighborware.com
America's Leading Community Network Software
>-----Original Message-----
>From: John Lucas [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, September 12, 2001 10:55 AM
>To: CF-Talk
>Subject: Re: Hierarchy
>
>
>http://www.secretagents.com/tools/freeviewlets/index.cfm?category_i
>d=20&show
>viewlets=1
>
>----- Original Message -----
>From: "Matthew W Jones" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, September 12, 2001 9:53 AM
>Subject: RE: Hierarchy
>
>
>> That should have read:
>> Is anyone using the "Nested Set Method" for Hierarchy's? Do you have any
>> implementation tips/tricks etc. (specifically towards insert, update, de
>> lete, reordering of an items left/right boundaries)?
>>
>> -----Original Message-----
>> From: Matthew W Jones [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, September 12, 2001 9:47 AM
>> To: CF-Talk
>> Subject: SOT:Hierarchy
>>
>> Is anyone using the "Nested Set Method" for Hierarchy's? Do you have any
>> implementation tips/tricks etc. (specifically towards insert, update,
>>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
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
