If you already have your query and you want to get the column names in your query use
queryName.columnList Then, something a lot more easier than selecting all tables from sysobjects <cfquery name="qDB" datasource="#request.mainDSN#"> sp_databases </cfquery> <cfoutput query="qDB"> #database_name#<br> </cfoutput> you can do the same thing with sp_columns ALL MS SQL off course ----- Original Message ----- From: "Rebecca Joy Sherman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, February 05, 2003 6:07 AM Subject: GET TABLES IN DATASOURCE / GET FIELDS IN TABLE > Help! I need to get the tables in a datasource and then the fields in a table. > Basically I would love to have something like Nates Two-select box with > tables and fields. > Can you please help? > > > 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
