: CF-Talk
Subject: RE: getting table column names
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,
Select *
from #tblname
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
A query is a structure of arrays. (OR was it an array of structures?) so
you should be able to just do something like:
#tempkey#
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
[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
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 name
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
6 matches
Mail list logo
