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