Well, I guess this is off-topic and probably a bit basic, but how do you write a recursive query? I have a need for it but I don't know how to do it. My db is access 2000.
Thanks, Matt Small -----Original Message----- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 8:39 PM To: CF-Talk Subject: RE: Build a tree of nodes/subnodes Or you can write a recursive stored proc. You have to get a little creative with Temp Tables and cursors though... But it's been done. Shawn Grover -----Original Message----- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 4:52 PM To: CF-Talk Subject: RE: Build a tree of nodes/subnodes At 06:48 PM 5/23/02, you wrote: >I usually do a recursive custom tag to make my trees. I haven't tried using >UDFs for it because of database calls, but with CFMX, I'm sure it would be The whole thing should only have a single DB call. Using a UDF on the results of the DB call is all that's needed. Unless I'm missing something in how your doing it. >nice. I haven't used the nested sets model before, but I have briefly >looked at it. My problem with it seems that it's not normalized at all. In >that Intelligent Enterprise article, the lft and rgt columns seem like they >could easily go out of wack if you're not careful. A single table with a >recursive parent ID seems much logical. > >Sure, there are some more database calls, but it all depends on what you're >trying to do. For example, we have an application with an advanced >permissions system that involves cascading permissions and some other >tidbits. When the user logs in, their permissions are pulled through >recursive custom tags and set to the session scope. It's a one time thing >for each login so any extra load is really not noticeable. > > > >Ben Johnson >Hostworks, Inc. > > ______________________________________________________________________ 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
