RE: getting table column names

Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 4:02 PM To: 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

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

RE: getting table column names

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

RE: getting table column names

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

Re: getting table column names

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# /CFOUTPUTBR /cfloop To get the list of columns returned in a query. At 10:19 AM 07/17/2001 -0700,

RE: getting table column names

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

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

Re: table column names

# DELIMITERS=, TD#Evaluate(QryResult. #CellValue#)#/TD /CFLOOP /CFOUTPUT /TR /TABLE - Original Message - From: Bruce, Rodney [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 16, 2001 5:32 PM Subject: table column names | Hello | | Is there a way to get the column names from