Another useful Access trick (to get Field Types). This will be handy once you get hold of the tables names.
SELECT VarType(YourColumn) AS AnAlias FROM YourTable <cfoutput> #YourQueryName.AnAlias# </cfoutput> http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=6&threadid=532387 > 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 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
