>>Using SQL Server 2000, is there any way to get (a) a list of non-system table names for a given database, and (b) any way to get the datatypes for database columns? This would be via two different queries.
Although it is possible to get these information from SQL Server, you may find it simpler using CFX_ODBCInfo. See http://www.contentbox.com/claude/customtags/ODBCInfo/E/TestODBCInfo.cfm This tag works with virtually any ODBC connection and is compatible with CF5 and CFMX. -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257711 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4