Mike,
Sure, thanks for responding:
Below is the code to create a query of five rows. Here's how they should
end up looking in the resulting tree:
Dave Phillips
--John Smith
--Chris Jones
--Robert Thompson
Patty Williams
I think you can probable follow it. The Sponsor refers back to the parent
AffiliateID.
Here you go...any help I can get is GREATLY appreciated on this. I'm
stumped:
<CFSET myquery = QueryNew("AffiliateID,FirstName,LastName,Sponsor") >
<CFSET temp = QueryAddRow(myquery)>
<CFSET QuerySetCell(myquery,"AffiliateID","11112222")>
<CFSET QuerySetCell(myquery,"FirstName","Dave")>
<CFSET QuerySetCell(myquery,"LastName","Phillips")>
<CFSET QuerySetCell(myquery,"Sponsor","")>
<CFSET temp = QueryAddRow(myquery)>
<CFSET QuerySetCell(myquery,"AffiliateID","33334444")>
<CFSET QuerySetCell(myquery,"FirstName","John")>
<CFSET QuerySetCell(myquery,"LastName","Smith")>
<CFSET QuerySetCell(myquery,"Sponsor","11112222")>
<CFSET temp = QueryAddRow(myquery)>
<CFSET QuerySetCell(myquery,"AffiliateID","55556666")>
<CFSET QuerySetCell(myquery,"FirstName","Robert")>
<CFSET QuerySetCell(myquery,"LastName","Thompson")>
<CFSET QuerySetCell(myquery,"Sponsor","11112222")>
<CFSET temp = QueryAddRow(myquery)>
<CFSET QuerySetCell(myquery,"AffiliateID","77778888")>
<CFSET QuerySetCell(myquery,"FirstName","Chris")>
<CFSET QuerySetCell(myquery,"LastName","Jones")>
<CFSET QuerySetCell(myquery,"Sponsor","33334444")>
<CFSET temp = QueryAddRow(myquery)>
<CFSET QuerySetCell(myquery,"AffiliateID","99990000")>
<CFSET QuerySetCell(myquery,"FirstName","Patty")>
<CFSET QuerySetCell(myquery,"LastName","Williams")>
<CFSET QuerySetCell(myquery,"Sponsor","")>
<CFDUMP VAR="#myquery#">
In case it gets cut off, here's what I'm trying to do:
I have an affiliate database that has a record like this:
affiliateID, affiliateName, sponsor
The sponsor, refers to the affiliate who referred another affiliate. So if
affiliateID 2 was referred by affliate ID 1, then 1 is in the sponsor field
for affiliateID 2, and since affiliateID 1 is not sponsored by anyone, then
their sponsor field is NULL.
What I need to do is show the entire affiliate structure in heirarchical
form...so on the first level of the tree, I have the affiliates who are not
sponsored by ANYONE...then, on the second level, the affiliates sponsored by
people on the first level would be collapsed underneath their respective
sponsor and be able to be expanded.
I think my problem lies in my sql query, but I'm not sure, and I've changed
it so much, rather than post it here, I'll see if someone has a quick answer
and knows how to do it right off. I'm sure it's simple, but since I've never
worked with CFTREE before, I just can't figure it out.
I'm using CFMX 7 and trying to do a FLASH cftree, but at this point, I'll
appreciate code that will work in FLASH or applet or any version of CF for
that matter.
Sincerely,
Dave Phillips
BizBreeze.com
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199596
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
