Try this, is this what you needed?

---nimer

<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","11112223")>

<CFDUMP VAR="#myquery#">

<cfform format="html">
<cftree name="t1" format="flash">

        <cfloop query="myQuery">
                <cftreeitem display="#firstname# #lastname#"
value="#AffiliateID#" parent="#Sponsor#">
        </cfloop>
</cftree>
</cfform>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:199599
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

Reply via email to