He has a new book specifically on trees. I'm not sure how much this is just rehashing what's in sql for smarties, but you might want to check this out: http://www.amazon.com/exec/obidos/ASIN/1558609202/qid=1108476965/sr=2-1/ref=pd_ka_b_2_1/002-6823342-1106443
----- Original Message ----- From: "Jeff Chastain" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Tuesday, February 15, 2005 7:52 AM Subject: RE: Tree Traversal / Storage Algorithm > Thanks everybody for the recommendation. I guess with this many people > saying it, I had better go check out this book. > > -- Jeff > > -----Original Message----- > From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] > Sent: Monday, February 14, 2005 10:35 PM > To: CF-Talk > Subject: RE: Tree Traversal / Storage Algorithm > > > >> From: Rob Munn [mailto:[EMAIL PROTECTED] Joe Celko has a great >> example of tree modelling using nested sets in "SQL for Smarties". In >> fact, he has a PHP class for doing just this released under gpl. Check >> it out: > > I don't know about the PHP class, but I can attest to Joe Celko's tree > using > nested sets as a great concept to learn! I use it a lot with hierarchies > of > permissions, etc. The SQL For Smarties book is one that makes you just > say, > "damn, I thought I knew a lot of SQL"!! > > Mike > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194725 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
