Not really sure why you'd need to, what with CF not being strongly typed...
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]
- How do I tell what fields are in my tables... cf talk
- RE: How do I tell what fields are in my tables... Philip Arnold
- Re: How do I tell what fields are in my tables... Critz
- RE: How do I tell what fields are in my tables... Shawn Regan
- RE: How do I tell what fields are in my tables.... Angel Stewart
- Re: How do I tell what fields are in my tab... Charlie Griefer
- RE: How do I tell what fields are in my... Angel Stewart
- Re: How do I tell what fields are ... Jochem van Dieten
- Re: How do I tell what fields are ... Charlie Griefer
- Re: How do I tell what fields are ... Claude Schneegans
- Re: How do I tell what fields are in my tab... Claude Schneegans
- RE: How do I tell what fields are in my tables... Aunger, Mitch
- Re: How do I tell what fields are in my tables... cf talk