try CFOUTPUT
Roger
>From: "Bruce, Rodney" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: getting table column names
>Date: Tue, 17 Jul 2001 16:02:00 -0700
>
>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
