Try this query. It returns everything. Exec sp_help tablename
-----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 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
