Pretty sure this only works with CF8 though. <cfquery name="myQuery" datasource="myDSN"> select * from table </cfquery>
<cfdump var="#myQuery.columnlist#" /> Paul. -----Original Message----- From: Kevin Huff [mailto:[email protected]] Sent: Monday, October 12, 2009 2:45 PM To: cf-newbie Subject: Dynamic Column Names Hey guys. I have a question. I'm working with a mySQL table that can have any number of columns. How can I get a list of these column names? I know it is stupid but I can't for the life of find the answer anywhere. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4848 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
