Getting query's field data type with ColdFusion

[anniemorin]

My question is that one:

Is there a way to catch the structure of a table from ACCESS with all the constraints and everything using ColdFusion?

I'm creating generic modules to be used with any table containing different fields. So a table may be named X and contains field1 of type integer, field2 of type string. And the table XY may be composed of field1 which is a date, field2 which is a string and field3 which is an integer.

If I use :

<cfquery name=&quot;&quot; datasource=&quot;&quot; dbtype=&quot;&quot;>
select top 1 * from tablename
</cfquery>

I use a loop on the record and a loop on the columnlist returned by the query.

But how can I know the type of the fields other than using isNumeric, isBoolean, isDate etc ?