I guess if the need arose, yes, you could probably whip up a UDF to loop over the columns of one of the rows returned, testing with the various functions you named...store that in a struct...with columnname as the key and the datatype as the value (?)
charlie
----- Original Message -----
From: Angel Stewart
To: CF-Talk
Sent: Thursday, October 02, 2003 8:09 AM
Subject: RE: How do I tell what fields are in my tables...
Hmm..
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. ?
-Gel
-----Original Message-----
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
nothing that returns field type.
cfquery returns 3 'special' vars in addition to the actual database
values.
1) queryname.columnlist - comma delimited list of column names
2) queryname.recordcount - the number of records returned from the query
3) queryname.currentrow - when cfoutputting over a query, the row
currently being output.
charlie
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]