thanks for help so far
ok I can get the column names and get a new query to run with them, but how
do I get the data.
Here is what I came up with,
<CFQUERY query1>
Select *
from #tblname#;
</CFQUERY>
<CFSET columnlist = query1.columnames>
<CFquery query2>
SELECT
<CFLOOP>
Loop through list
</CFLOOP>
FROM #tblname#;
</cfquery>
both querys work, but looks like I am just repeating same thing, a
different way.
how can I now print data to screen.
thanks again
-----Original Message-----
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 17, 2001 1:58 PM
To: CF-Talk
Subject: RE: getting table column names
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
