Ah. You are using MS Access. I hadn't realized this. And haven't used it in a few years.
You're not stupid. Just getting incomplete advice. =) I think sp_columns is what works on Access. If not, it uses the SHOW command. One or the other. sp_columns/tables way: Columns in a Table <cfquery name="queryName" DATASOURCE="dataSource"> sp_columns 'tableName' </cfquery> To see what columns it returns, <cfoutput>#queryName.columnList#</cfoutput> Tables: <cfquery...> sp_tables 'dbName' </cfquery> Otherwise <cfquery name="queryName" DATASOURCE="dataSource"> show tables </cfquery> <cfquery name="queryName" DATASOURCE="dataSource"> show columns from tableName </cfquery> (I think) Jerry Johnson >>> [EMAIL PROTECTED] 02/04/03 04:56PM >>> I took all examples and could not get any of them to work..... :-( Joy ;-* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
