On 9/20/07, Vince Collins <[EMAIL PROTECTED]> wrote: > The data within the database changes, not the schema per se, however I > do want to pass sorts and filters to these queries. > > application vs request is unclear now to me. If I allow them to filter > the query or sort it, I thought it should be scoped to request. No?
If you're storing the full inventory in the CFC, then you'd have a filter method that would perform a query of queries and return the filtered or sorted data, but not actually modify the internal data within the CFC. But if you have a lot of inventory, you probably don't want to store the inventory in the CFC because the database does a much better job of filtering and sorting data than Coldfusion does. -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288950 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
