RE: [CFCDev] table DAO

[Marlon Moyer]

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 = www.mail-archive.com/[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]