I have a client who wants me to build a "No-flush Binary marketing" application in SQL and CF. I've looked at several examples and really don't know how to approach building an infinite tree structure of this sort. Can anyone point me to resources for learning how to develop this type of system, implementing business rules and calculating commissions? I've never worked with MLM stuff. At first glance it seems fairly simple, but the further I get the more questions pop up. The big thing here is probably speed in calculating the left/right percentages and processing downline commissions - it's an infinite structure... Anyway, thanks for any information anyone can provide.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

