you should look at Joe Celko's work on using set theory to manage heirarchies, built to handle this sort of stuff... http://www.intelligententerprise.com/001020/celko.shtml
-----Original Message----- From: Jason Davis [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 20:20 To: CF-Talk Subject: Meet my tables Meet my Products table: CREATE TABLE [Products] ( [Product_id] [int] NOT NULL , [Product_title] [varchar] (200) NULL , [Category_id] [int] NOT NULL , ) Each product has a category, meet my categories table: CREATE TABLE [Categories] ( [Category_id] [int] NOT NULL , [Category_parent] [int] NULL , [Category_title] [varchar] (200) NULL , [Category_count] [int] NULL DEFAULT (0) ) As you can see, each category has a Category_parent which symbolize the above category (categories are sorted hirarchly). Can I do some kind of a loop that will run for each Category_id, and store in Category_count the number of Products available in that category, and all of the hirearchy categories beneath? i.e - if I have the following categories: (1) Printers (2) Laser (category_parent=1) (3) Ink (category_parent=1) and the following products: HP LaserJet (category_id = 2) HP Deskjet (category_id = 3) Canon BJ200D (Category_id = 3) category count will be: (1) Printers => 3 (1+2) (2) Laser => 1 (3) Ink => 2 Help!? ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
