>At some point, the client has *got* to stop adding features! I've pretty
no they don't, and if you don't stop them they will keep adding features
forever.
("I heard about this new do dad at a cocktail party Flushus an I went to, If
you could just go ahead and add that in that'd be great. Just put it under
that button.")Rob -----Original Message----- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 12:27 PM To: CF-Talk Subject: RE: Self Join Question Thanks... At some point, the client has *got* to stop adding features! I've pretty much figured a way to PREVENT sub branches from having their own subs, so at least that part of the problem is licked! Les :> select B1.Branch_Name, B2.Branch_Name :> FROM :> Branches B1 :> LEFT JOIN :> Branches B2 :> ON B1.branch_id = B2.sub_branch :> :> Might have to play with the join a little bit, but that's the :> basic concept. :> :> This only does branches and sub-branches. It gets significantly more :> complex when your sub branches have their own subs, and sub's subs have :> subs, etc. At that point, depending on the size of the data, it's often :> much easier to just load it all into a structure and process in CF (faster :> too).http://www.fusionauthority.com/ads.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
