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
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
