I'm still a bit confused. Perhaps it is because I misunderstand your purpose.
Components do not store data in the same way that databases do. I think you are on the right track to incorporate object oriented methodologies into your development, though. You have a content object with the properties: ContentID, Title, DateAdded (etc). And some methods: add, (etc) Are you planning on running queries from the database, then invoking the component and 'populating' the properties? Or... ?? At 01:07 PM 6/26/2002 -0400, you wrote: >Well, I'll be using CFC's to create the components (i'm attempting to >create the class structures, i'm just not sure how to store the data >they represent). Also, There will be additional items related to >content... Things such as images, events etc., all which should inherit >the generic properties of content. > >Does that help? > >Thanks! > >-----Original Message----- >From: Jeffry Houser [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, June 26, 2002 12:57 PM >To: CF-Talk >Subject: Re: > > > I'm not sure if you are you trying to create an Object Oriented class >structure, or a database design, so I'm a bit confused all around. > > But, based on my understanding... > > You have two tables: a content table and a document table. The >content >table contains a lot of generic information that relates to many >different types of data. The document table is a specialized version of > >'content'. > > I would put the ContentID in the Document table. > > If your content table doesn't relate to anything other than than >document, then there may not be a need for two tables. > >At 12:00 PM 6/26/2002 -0400, you wrote: > >Hello everyone, I'm wondering how I would represent the following case > >in > >a database. > > > >I have a general content class that contains generic information about > >a > >piece of content. I then have more specific classes such as document > >(which will inherit the content class). How would I go about relating >the > >two in the physical database? So far classes look like so: > > > >-------------- > >| content | > >-------------- > >| -contentID | > >| -title > >| -dateAdded | > >| -etc... | > >|------------| > >| +add(s) | > >| +etc... | > >| | > >-------------- > > > >-------------- > >| document | > >-------------- > >| -documentID| > >| -fileName | > >| -fileSize | > >| -etc... | > >|------------| > >| +upload(s) | > >| +etc... | > >| | > >-------------- > > > >How do I represent the 'document' is a 'content' relationship in the > >DB? > >Would the content class contain the ID of the more specific class (ID >of > >the document)? > > > >And please excuse me if my ASCII art isn't up to par :) > > > >Thanks, > > > >Phillip > >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 > >-- >Jeffry Houser | mailto:[EMAIL PROTECTED] >Need a Web Developer? Contact me! >AIM: Reboog711 | Fax / Phone: 1-203-379-0773 >-- >My CFMX Book: ><http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20> >My Books: http://www.instantcoldfusion.com >My Band: http://www.farcryfly.com > > > ______________________________________________________________________ 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
