As part of my learning process with CF, I've managed to write myself
a page that will output the contents of any table, once I've fed it
the table name. (Yes, columnList featured heavily).

Now I'd like to go one further, and have a page that will let me
update records, delete records, and maybe even add new records, to
any generic table. No, it probably won't be pretty, but it'll be a
useful tool. I've figured out how to do the coding in a single page
for a non-generic table, with assorted forms in the output and some
cfupdates and so on at the top of the page, I "just" need to make it
generic.

But, to make this half-way usable, I really need to be able to pick
up the datatype of each column, not just the name. As far as I can
see, columnList and related variables don't do this.

Any ideas? Is there a datatype(variable) sort of function hiding
somewhere?

(At present this is on Access, BTW. But since this is meant to be
a "learn CF" process, I'd like a DB-independent solution if possible).

I suppose for a practical solution (though one that would only work
on my own DBs) I could impose a naming convention on myself, so the
name of the column includes its data-type. But that looks too much
like admitting defeat :(