Welcome to the DBIx::Tree module. This modules lets you turn things like: food food_id parent_id ================== ======= ========= Food 001 NULL Beans and Nuts 002 001 Beans 003 002 Nuts 004 002 Black Beans 005 003 Pecans 006 004 Kidney Beans 007 003 Red Kidney Beans 008 007 Black Kidney Beans 009 007 Dairy 010 001 Beverages 011 010 Whole Milk 012 011 Skim Milk 013 011 Cheeses 014 010 Cheddar 015 014 Stilton 016 014 Swiss 017 014 Gouda 018 014 Muenster 019 014 Coffee Milk 020 011 into: Food (001) Dairy (010) Beverages (011) Coffee Milk (020) Whole Milk (012) Skim Milk (013) Cheeses (014) Cheddar (015) Stilton (016) Swiss (017) Gouda (018) Muenster (019) Beans and Nuts (002) Beans (003) Black Beans (005) Kidney Beans (007) Red Kidney Beans (008) Black Kidney Beans (009) Nuts (004) Pecans (006) There are a couple of examples in the examples/ directory. To build this, do the following (Unix and Unix-like systems): perl Makefile.PL make make test make install or (Win32 with MS Visual C++): perl Makefile.PL nmake nmake test nmake install When you tell a user id and password to the configuration portion of Makefile.PL, be aware that this is being stored in a file called PWD. It is recommended that you only choose a user id and password on a non-production server, since this module will drop and create a table in that data source (the food table). As of this version, this has only been tested on: Windows NT 4.0 SP3, ActivePerl 502, DBD::Sybase Sparc/Linux 2.0.35, Perl 5.004_04, DBD::mSQL RedHat Linux 6.1, Perl 5.005_04, DBD::mSQL Mac OS X, Perl 5.6.0, Mac OS X 10.2.4 Brian Jepson, bjepson@jepstone.net Sourceforge Project Page: http://sourceforge.net/projects/dbix-tree/