I'm developing a survey application, and right now, I'm working on the reporting part of the app. The survey results are in a table 'Result'. The user's access is limited to certain records based on management level and organization. The user is able to filter results on fiscal year and quarter or on a date range. My thinking is that the database query should be in a CFC in the model layer and should return all survey results to which the user has access. The filtering (and sorting and paging) would be in a controller in the session scope. The controller would cache the entire recordset from the model layer and return the appropriate filtered, sorted data to the view layer (cfm page) as a query or structure in the Request scope. Is this a correct application of the MVC framework? Anything that could be done better? Thanks in advance, Joe
You are subscribed to cfcdev. To unsubscribe, please follow the instructions at http://www.cfczone.org/listserv.cfm CFCDev is supported by: Katapult Media, Inc. We are cool code geeks looking for fun projects to rock! www.katapultmedia.com An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
