Can you write an example of your data, maybe 5 rows using the query functions to build it (queryNew(), queryAddRow(), querySetCell()). This way it's easy to post and everyone can run it.
If you can post this, then we can tweak the QofQ sql and the cftree so it works. ---nimer -----Original Message----- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Sunday, March 20, 2005 1:08 PM To: CF-Talk Subject: Please help with CFTREE Hi all, Okay, I searched the archives, and I've gone through the docs in CF MX 7 and I still can't get my CFTREE to display the way I want it to. I know it must be simple, and I'm sure a ton of people have done it before, and it may be my lacking experience in SQL as well, but I'm not sure...In any case, I need help, ergo I write you. :) Here's my dilemma: 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. Thanks in advance! Sincerely, Dave Phillips BizBreeze.com [EMAIL PROTECTED] 615-746-3851 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199549 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
