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
