I just found your group and have been trying to find time to make it to one of your meetings.
Anyway, I have a question I hope someone will be able to answer. I am trying to display database information dynamically and need to get the data type so that the information can be displayed correctly. This will be hosted on a third party server so we have no control over what is installed and we won't be able to place a full drive path for the tags I have found. I am using CF5 and Microsoft Access.
I am currently getting the column names with this:
<CFQUERY NAME="Data" DATASOURCE="#ODBCconnection#" MAXROWS=1 DBTYPE="ODBC">
SELECT * FROM table_name
</CFQUERY>
<CFLOOP INDEX="FieldName" LIST="#Data.ColumnList#" DELIMITERS=",">
<CFOUTPUT>#FieldName#</CFOUTPUT>
</CFLOOP>
Can anyone point me in the direction of how to also get the data types for each column, or a custom tag that will get both the column names and data types?
Thank you,
Adam Dayhoff
HNTB Corporation
Overland Park, Kansas
(913) 491-9333
Fax: (913) 491-4865
**********************************************************************
This e-mail and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. If you are NOT the intended recipient or the person responsible
for delivering the e-mail to the intended recipient, be advised that you
have received this e-mail in error and that any use, dissemination,
forwarding, printing, or copying of this e-mail is strictly prohibited.
**********************************************************************
