paris lundis wrote: > 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.?)
If your database implements the INFORMATION_SCHEMA from the SQL standard take a look at the view COLUMNS. It should get you the datatype, default value, nullability, max character length and some more exotic attributes. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
