On Thu, Oct 28, 2010 at 01:09:59AM +0000, Mark wrote: > Is there a recommend way to deal with hierarchical data with SQLObject? > I think I'm going to simply keep track of my categories and their > hierarchy outside of SQLObject classes and then simply have all of my > objects contain a category id so I can list them under the proper > category. > > Reference: > http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
See also http://onlamp.com/pub/a/onlamp/2004/08/05/hierarchical_sql.html Oleg. -- Oleg Broytman http://phd.pp.ru/ p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------------------------------ Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss