>
> So how would you determine the field type of the underlying table for a
> query?
>
> Manually test each field with IsNumber,IsDate,IsBoolean etc. etc. ?
That is why you should use the INFORMATION_SCHEMA. Just try
<cfquery datasource="" name="qColumns">
SELECT *
FROM information_schema.columns
WHERE table_name = 'myTable'
</cfquery>
<cfdump var="qColumns">
You should also check out the rest of the INFORMATION_SCHEMA, it
allows you to see (almost) everything of the schema (in a
compliant database), from the datatypes and defaults of columns
to the permissions and triggers defined on a table.
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
