Not complete against the idea of writing a paper, even though that is not really my thing, IE I have never done it before. It would probable be a week or three before I had the time, but other then that sure, why not.
P.S. Why is it not possible? I missed the earlier post. The technique I had in mind has the fields built right in the SQL statement (as apposed to something done directly in the database design). This is not possible in your case? I would not be surprised if it is not possible, just making sure before abandoning the possibility. -------------- 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 12:06 PM ...To: CF-Talk ...Subject: RE: Extra query info ... ...Someone mentioned that already and it's not possible in this instance. On ...the other hand, you are correct that it's an under utilized technique. ...Care ...to write up a small paper on it? ;) ... ...> 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. ... ... ... ... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:190822 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