Use the following after running your query:
query_name.columnList
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
[EMAIL PROTECTED]
-----Original Message-----
From: Bruce, Rodney [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 17, 2001 12:20 PM
To: CF-Talk
Subject: getting table column names
Hello
Is there a way to get the column names from a table, if you don't
know them.
I am passing a table name to a page then need to look up information in that
table. because I am going to be passing a number of table names, I can't
use column names from any one table.
The tables are of various sizes with anywhere from 4 to 20 columns.
how can I display the query results?
example:
<CFQUERY>
Select *
from #tblname#;
</CFQUERY>
The query itself works fine, but I don't know how to get to the results
Thanks for any help
Rodney
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
