Try this query show columns from table_name
the resulting columns from that query are Field, Type, Null, Key, Default, Extra Best of luck Chris Griffin [email protected] Oceanus World Link Services, Inc. 34 Jerome Ave, Suite 114 Bloomfield, CT 06002 On Oct 12, 2009, at 2:45 PM, Kevin Huff wrote: > > 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:4849 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
