No, only one table. I believe Doug Bezona and I are suggesting an identical approach (so you now have a consensus solution).
> -----Original Message----- > From: Doug Brown [mailto:[EMAIL PROTECTED] > Sent: Monday, August 21, 2006 12:26 PM > To: CF-Talk > Subject: Re: Database design question > > Thanks michael, but if I do it that way, will I not have hundreds of > tables? > I currently have about 24 categories and each category has prob 10-50 > sub_categories and then each sub_category has it's own set of > sub_categories. > > > > ----- Original Message ----- > From: "Michael E. Carluen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[email protected]> > Sent: Monday, August 21, 2006 12:53 PM > Subject: RE: Database design question > > > > Doug, yYou can actually use a single table for that. One way is to > create > a > > field that serves as a "parent_id". > > > > Example: > > > > ID: 1, NAME: Antiques and Vintages, PARENT_ID: 0 > > ID: 2, NAME: Antique Furniture, PARENT_ID: 1 > > ID: 3, NAME: Vintage Cars, PARENT_ID: 1 > > ID: 4, NAME: Hutches, PARENT_ID: 2 > > ID: 5, NAME: DeSoto, PARENT_ID: 3 > > > > Hope that makes sense, Doug. > > > > Michael > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250505 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
