Coincidentally, I just wrote about this in response to someone else's question. Not sure if any of this would help you:
http://www.bennadel.com/blog/674-Ask-Ben-Adding-A-Column-From-Second-Que ry-To-First-Query.htm OR: http://www.bennadel.com/index.cfm?dax=blog:674.view This doesn't talk about "calculated" cells, but it might point in you in a direction that gets you there. ...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Thursday, May 03, 2007 9:02 AM To: CF-Talk Subject: Query Object Hello Guys, Is it possible to loop through a query object and add additional columns containing calculated data? I'm sure I've seen a function like queryNew() or something like that. I've got a query returned from the database, I'm just looking to append a few extra columns. Thanks, Rob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by AdobeĀ® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276909 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4