> 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?
I think your objects should generally correspond to logical database entities, not necessarily physical records within tables. For example, let's say you have orders and lineitems within your database. You'd probably want an order object to contain the appropriate information about related line items. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ---------------------------------------------------------- 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]
