A query is a structure of arrays. (OR was it an array of structures?) so
you should be able to just do something like:
<CFLOOP collection=#queryname# item="tempkey">
<CFOUTPUT>#tempkey# </CFOUTPUT><BR>
</cfloop>
To get the list of columns returned in a query.
At 10:19 AM 07/17/2001 -0700, you wrote:
>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
