The object would have 2 properties not another object within it. The properties would be a status code (numeric) and a status description (text). Status description would be a read only property whilst status code would be readable/writable and would update status description on being set.
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > On Behalf Of Joe Rinehart > Sent: Tuesday, November 16, 2004 7:21 PM > To: [EMAIL PROTECTED] > Subject: Re: [CFCDev] table DAO > > Marlon, > > Do you mean that you'd set the "status" property of the object to the > description's value, or you'd use the information from the second > table to instantiate a status object as the status property of the > main object? > > -joe > > > On Tue, 16 Nov 2004 15:11:20 -0600, Marlon Moyer > <[EMAIL PROTECTED]> wrote: > > > > > > > > Okay, you got me there, the select = portion of my DAO's may use > joins, i.e > > joins to get status descriptions = from status codes and such, but the > > insert and updates only access 1 table = each. I'm sure that I'll come > up > > against something that won't quite = fit that way one day, but so far it's > > worked out = fine. > > > > > > > > > > > > > > ________________________________ > > > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > On Behalf > > Of Steven Boynes > > Sent: Tuesday, November = 16, 2004 2:42 PM > > > > > > To: [EMAIL PROTECTED] > > Subject: Re: [CFCDev] = table DAO > > > > > > > > > > > > > > > > What if the object spans multiple tables that = could take advantage > of > > joins? ...how do you "join" the DAOs? = .... I guess really there should be > > 1 DAO per object, where an object can = correspond to one table but > does not > > necessarily. I'm sure you could come up = with a way to do joins on the > > individual DAOs but then you're basically = recreating the database > > structure in coldfusion and whats the point of = that? > > > > >From: Marlon Moyer <[EMAIL PROTECTED]> > > > > >Reply-To: [EMAIL PROTECTED] > > > > >To: [EMAIL PROTECTED] = > > > > >Subject: Re: [CFCDev] table DAO = > > > > >Date: Mon, 15 Nov 2004 15:07:02 -0600 = > > > > > > > > > >I do it in such a way that an object may have several DAO's > associated > > > > >with it. If an object spans multiple tables, it = will use a > > > > >corresponding DAO for each table. = > > > > > > > > > > > > > > > > > > > > > > > > >On Mon, 15 Nov 2004 14:22:00 -0600, Dawson, Michael = > <[EMAIL PROTECTED]> > > wrote: > > > > > > But, theoretically, you shouldn't think in terms of = tables, but think > > in > > > > > > terms of objects. An object may need to = store data in multiple > > tables. > > > > > > You would then have a DAO for that = object. In the DAO, you > may have a > > > > > > method "create()" that inserts a new record = in the main table, > then > > > > > > inserts a default child record in a userType table. = > > > > > > > > > > > > Or, is that the business logic that handles that? = > > > > >---------------------------------------------------------- = > > > > >You are subscribed to cfcdev. To unsubscribe, send an email = > > > > >to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' = > > > > >in the message of the email. > > > > > > > > > >CFCDev is run by CFCZone (www.cfczone.org) and supported = > > > > >by Mindtool, Corporation (www.mindtool.com). = > > > > > > > > > >An archive of the CFCDev list is available at = > > [EMAIL PROTECTED] = > > ---------------------------------------------------------- You are > > subscribed to cfcdev. To unsubscribe, send an email to > [EMAIL PROTECTED] > > with the words 'unsubscribe cfcdev'=20 in the message of the email. > CFCDev > > is run by CFCZone (www.cfczone.org) and supported by Mindtool, > Corporation > > (www.mindtool.com). An archive of the CFCDev list is available at = > > [EMAIL PROTECTED] > > > -- > For Tabs, Trees, and more, use the jComponents: > http://clearsoftware.net/client/jComponents.cfm > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email > to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' > in the message of the email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported > by Mindtool, Corporation (www.mindtool.com). > > An archive of the CFCDev list is available at www.mail- > [EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at [EMAIL PROTECTED]
