now that's a cool feature of Oracle :) We are using Access, MySQL and MSSQL 2000... depends on the project/client...
-paris ---------- Original Message ---------------------------------- From: <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 18 Mar 2003 13:28:19 -0600 >what RDBMS are you using? In Oracle you can hit the data dictionary > >SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH, NULLABLE, DATA_DEFAULT > FROM ALL_TAB_COLUMNS > WHERE TABLE_NAME = 'TABLE_NAME' > ORDER BY COLUMN_ID > >Doug > >>-----Original Message----- >>From: paris lundis [mailto:[EMAIL PROTECTED] >>Sent: Tuesday, March 18, 2003 1:24 PM >>To: CF-Talk >>Subject: fetching the field type ? >> >> >>Working with any database in CF is easy and most of us know >>where we can find the field names of a fetched query - >>programmatically... >> >>Does anyone know off hand if it is possible to retrieve or >>otherwise determine the field types that match the field >>names? (ie: text(length), integer, etc.?) >> >>One of those missing pieces to creating some interesting >>reusable widgets.. >> >>-paris >> >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
