I have done this with dynamic data populating two levels. So I suggest you
get an example working like that first and then introduce the variable
number of levels.
I had 2 query results, so I populated the array with nested loops. The inner
loop depended on there being a value to add:
<CFOUTPUT QUERY ="Query1">
outtercounter + 1
<cfif there is an inner item relating to query1>
<cfloop query="query2">
populate innner array
</cfloop>
</cfif>
add item to outer array
</cfoutput>
Hence you could have more levels by nesting CFIF conditions where there is
an item to drill down on. It it not clear which part of all this you are
having problems with but I guess it is the multiple, dynamic levels part.
Cheers,
Dave
----- Original Message -----
From: "Jason Aden" <[EMAIL PROTECTED]>
To: "Spectra-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, 15 March, 2001 2:07 PM
Subject: cfa_tree
> All:
>
> I'm having some trouble dynamically generating a drill down using
cfa_tree.
> I'm running into many problems when trying to convert a query containing
> hierarchy data into the array of structures necessary to pass cfa_tree for
> dynamic tree generation with a dynamic number of levels.
>
> To those out there who have solved the problem of creating a dynamic
> drilldown with cfa_tree, any suggestions on how to do it? Do you have any
> code you would be willing to share? Any help would be greatly appriciated.
>
> Thanks,
>
> Jason
>
> ----
> Jason Aden
> Allaire Certified Developer
> [EMAIL PROTECTED]
> www.wwstudios.com
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
