I am quite new to Flex and was planning on learning it very soon  
which ended up being sooner than I thought because of a project that  
could really use it. So here I am.

The application I am designing needs to display a hierarchal list of  
codes. All the codes are related to each other in that one is abover  
another.

For example the structure resembles the following:

AA
        AAA
        AAB
                AABA
                AABB
                AABC
                        AABCA
                        AABCB
                        AABCC
                        AABCD
                AABD
        AAC
        AAD
AB
        ABA
        ABB
        ABC
        ABD
        ABE
        ABF

Inside my database there is a table that raggedly displays this data  
in 11 columns (the 11 levels)

1               2                       3                       4               
        5                       6                       7                       
8                       9                       10              11
AA              AAA
AA              AAB             AABA
AA              AAB             AABB
AA              AAB             AABC            AABCA
AA              AAB             AABC            AABCB

etc

So I want to query this data in which case I have already built a  
function in ColdFusion to return the DISTINCT items for a level that  
I specify

Which in my example would produce

AA
AB

for level 1

I am able to return that much to a tree and have it display the  
folders by adding a column pragmatically to the Query called  
"children". There are 10s of thousands of records in this table so I  
do not want to grab all this data at once. I want the next level for  
a specified entity to be pulled from the CFC when I click it. How do  
I append this information to a folder item?

Thanks a bunch!
-Kyle

Reply via email to