Found this old piece of code .... hope it helps
<CFSET Table = "MyTable">
<CFSET Datasource= "myDsn">
<CFSET dbusername= "admin">
<CFSET dbpassword= "">
<CFSET columnlist="">
<CFOBJECT type="COM" name="MyConnection" class="ADODB.Connection"
action="CREATE">
<CFSET TEMP = MyConnection.Open("DSN=#Datasource#","#dbusername#",
"#dbpassword#", -1)>
<CFSET ColumnNames = MyConnection.OpenSchema(4)>
<CFSET RSfields = columnnames.Fields>
<CFSET Tablename = RSfields.Item("TABLE_NAME")>
<CFSET Columnname = RSfields.Item("COLUMN_NAME")>
<CFLOOP condition="NOT ColumnNames.EOF">
<CFSET Column = Columnname.Value>
<CFSET Table2 = Tablename.Value>
<CFIF not listcontains(columnlist,Column) AND Table2 is "#Table#">
<CFSET columnlist = listappend(columnlist,Column)>
</CFIF>
<CFSET temp = ColumnNames.MoveNext()>
</CFLOOP>
<CFSET CALLER.getColumns = QueryNew("column_name,type_name,length")>
<CFSET temp = QueryAddRow(CALLER.getColumns , listlen(columnlist) )>
<CFSET x=1>
<CFLOOP list="#columnlist#" index="column">
<CFSET temp = QuerySetCell(CALLER.getColumns, "column_name", column ,
x)>
<CFSET temp = QuerySetCell(CALLER.getColumns, "type_name", "text" , x)>
<CFSET temp = QuerySetCell(CALLER.getColumns, "length", "10" , x)>
<CFSET x=x+1>
</CFLOOP>
<CFSET temp = MyConnection.Close()>
It's bad code, inefficient, not documented... but it worked .... I think I
used it to mimic sp_columns in SQL. I think you have to create a regular DSN
for this to work.
Shlomy Gantz
Certified Macromedia Instructor
President, Bluebrick Inc.
-----Original Message-----
From: Terry [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2003 6:32 PM
To: CF-Talk
Subject: How to get field names in MSAccess
I know this is simple, but can't remember.
How do use a query to get list of column or field names. Using CF5.0
Thanks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
