On Fri, 29 Oct 2004 11:26:07 -0400, Daniel Farmer wrote: > Is there a syntax that you can pass to a MS Access Db to get a list of column names > for a particular table?
I'm not sure about actually within access, but you could always do this: <cfquery name="myquery" datasource="dsn" maxrows="1"> SELECT * FROM myTable </cfquery> <cfoutput> #myQuery.columnList# </cfoutput> That should get you the list of the columns returned in the query. Scott -- ----------------------------------------- Scott Brady http://www.scottbrady.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182945 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
