Pete, Try this:
http://www.bennadel.com/blog/357-Ask-Ben-Changing-ColdFusion-Query-Colum n-Names.htm [OR: http://bennadel.com/index.cfm?dax=blog:357.view] ...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 21, 2007 12:35 PM To: CF-Talk Subject: Renaming a query column? Hi all, I'm working on a webmail interface that supports both POP (suing CFPOP) and IMAP (using Rick Root's imap.cfc). I'd like to use a single set of interface components, but the column names returned by cfpop and imap.cfc don't completely mesh up (i.e. cfpop "queryname.attachments" and imap.cfc's "queryname.attach"...of course, imap.cfc doesn't return anything from that column anyway, but I'll tackle that later) Is there a simple way to rename a column name in a query result set, apart from setting aliases in a QoQ or using queryAddColumn()? It seems like there should be a simpler way to rename a column in a query result set. Thanks, Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:273300 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
