if you are going to recalculate the Tree each time the tree changes then just have a integer field called perhaps VisualDisplayOrder added to the Categorys table. When you recalculate the tree , update this field for each record. Then when you want to generate the Tree for a visitor, just SELECT * FROM CaTEGORYS ORDER BY VisualDisplayOrder. For really large Trees that don't change that often this isn't half bad at all. ----- Original Message ----- From: Dave Hannum <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Friday, July 28, 2000 4:33 PM Subject: Writing outpout to a file or DB > Hello, > > I have a navagation menu on the new version of our site that is dynamically > driven from categories of products in a catalog. To save CPU and load time, > I'd like to generate the links on this menu in the background with a script > that would run whenever the catalog is changed. (added to, deleted from, > modified any way). What's the best way to save this info? Now, note that > this is on an shared ISP box, so CFFILE is not an option and CFX tags are > not an option. Is there someway to save the layout in a LongText field of > the database? Any other suggestions? > > The result will look something like this: > > >Category One > >SubCat One One > >SubCat One Two > >Category Two > >SubCat Two One > >SubCat Two Two > >SubCat Two Three > >Category Three . . . etc > > Thanks, > Dave > > > ================================= > "What we need is a list of specific unknown problems we will encounter" > > David Hannum > Authentic Country Traditions > www.countrytraditions.com > > > > > -------------------------------------------------------------------------- ---- > Archives: http://www.mail-archive.com/[email protected]/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
