Also, have you considered having the database doing the calculations and create the new fields, then it's already for the ColdFusion once the record set it returned.
You probably have, but I wanted to throw this out, as it's an under utilized technique. -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning ...-----Original Message----- ...From: Michael Dinowitz [mailto:[EMAIL PROTECTED] ...Sent: Monday, January 17, 2005 9:29 AM ...To: CF-Talk ...Subject: Extra query info ... ...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:190819 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
