Right. That's the first option below. Looks like that's the one to go with. Problem is, it makes the debug look a mile long. :(
> If you're using CFCs it would make more sense to create a function > that takes a set of data (one row) manipulates it and returns > something else. This way the function can be utilized everywhere > instead of just for a query. If you're feeding the whole data set to a > CFC why not just make an include file... > > After the initial call of the CFC (assuming it stays in memory) > subsequent calls are fast. > > Adam H > > On Mon, 17 Jan 2005 12:28:31 -0500, Michael Dinowitz > <[EMAIL PROTECTED]> wrote: > > Here's a conceptual question. Lets say you have a query with multiple > rows > > in it. There is a few calculations that will take place between items in > a > > row to get some additional values per row (i.e. a discount price, etc.). > > One way of doing this is when outputting the query, you send the > specific > > data to a CFC (It's used in multiple places) and get out a structure. > This > > means that a 20 row query has 20 calls to the CFC. > > Another way of doing it is to pass the whole query to a CFC which will > then > > loop over the query, do the calculations and then place the results into > new > > columns within the query. > > The first has a single loop but multiple CFC calls while the second has > 2 > > loops (inside the CFC and out) but a single CFC call. > > Which do you prefer? Do you see a problem with either approach? > > Just something that came into my mind while rewriting a few dozen pages > on > > this ecommerce site. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190828 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
