If you find nothing, have a look under the hood. You might be able to do it with some Java calls.
Adrian -----Original Message----- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: 21 March 2007 16:35 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273283 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

