>Pretty sure this only works with CF8 though. > ><cfquery name="myQuery" datasource="myDSN"> >select * from table ></cfquery> > ><cfdump var="#myQuery.columnlist#" /> > >Paul. > >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.
COLUMNLIST! How could i not see that anywhere. The sad part is I think I've used that somewhere else before. I guess that is why I'm a Newbie, or as us young'ins say n00b! Anyway thanks a lot to both of you for your help. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:4850 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
