You could build a recursive template that simply displays data in a tree structure - although it wouldn't look like the CFTREE output. We use a multi-select box here to build parent-child relationships for certain data. With this method though you have to dynamically name the queries otherwise CF gets confused.. Darryl -----Original Message----- From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 7:16 AM To: CF-Talk Subject: Recursive Tree Structure Okay, I'm coming up empty here. I'm using the cf_selectboxbuildtree tag with some modifications to show our db of publications. All is well. Now, my boss wants me to create a page that will pull out just the publications that are identified by a 1 in a field in a corresponding table, but still use the tree format. Thoughts? Thanks. d Tree table looks like this: nodeid, nodename, parentid, pubid (pubid is null if it's just a branch of the tree and not an actual publication) pubid is the matching field in the pubs table. ************************************************************ Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
