> -----Original Message----- > From: Burhan Khalid > Sent: Monday, May 03, 2004 6:59 AM > > I'm once again faced with a database design problem, and not quite > sure what is the best way to solve it. The task is to design one of > those unlimited category directories. Like dmoz.org or yahoo > directories, et. al. Thanks for the two great article links, Sarah and Joshua. I forwarded them on to some people here at my company, and was reminded of another potential method by my Oracle DBA, if you have Oracle and don't mind being database-specific. Oracle has special syntax, something like, "SELECT ... CONNECT BY ... START WITH ..." for retrieving a tree-structured data branch starting at any given node. I've used it before, and It's pretty powerful, at the expense of being specific to Oracle only. If you are interested, a comprehensive introduction is here: http://otn.oracle.com/oramag/webcolumns/2003/techarticles/gennick_connectby. html - John -- This message may contain information which is private, privileged or confidential and is intended solely for the use of the individual or entity named in the message. If you are not the intended recipient of this message, please notify the sender thereof and destroy / delete the message. Neither the sender nor Sappi Limited (including its subsidiaries and associated companies) shall incur any liability resulting directly or indirectly from accessing any of the attached files which may contain a virus or the like.