I have a couple of questions about the data abstraction layer: 1. How do you handle retrieving data from multiple tables that are joined in the SQL.
2. Do you use SQL SELECT/INSERT/UPDATE/DELETE statements or stored procs? 3. What if you only need to return a single column from a multi-column table? Do you specify which columns are returned which, in turn, would create a dynamic SQL statement? 4. Can someone post an example CFC that performs these SQL actions? Thanks "Adam Cameron" wrote >> Each DB table has a CFC that relates to it, and might have methods >> like get(), add(), update(), delete(). The get() function will take >> an argument for each field of the table, to allow filtering >> (basically chucking it in a where statement), as well as an >> additional 'whereClause' argument for stuff that ain't a direct col=value filter. ---------------------------------------------------------- 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]
