Programming question

>> There is a way to preserve the original order?
> Yes, there is, but I do not know it.

getMetadata()
http://livedocs.adobe.com/coldfusion/8/functions_e-g_50.html

--
Adam

>> sorry, this line just gives me the column names (ie., red, blue, yellow). It does not display the data.
>
> No it doesn't, but didn't it give you some ideas on how it might.

There's some docs here:
http://livedocs.adobe.com/coldfusion/8/Variables_18.html

--
Adam

The second approach, <cfloop list="#cols#" index="col">, works really well. Thanks a bunch!!!

There is probably a better way, but the only way I've found to preserve the order is to set the order like you did in the cols variable, then put the query into an array with the col name as one of the fields, and then sort them out based on the cols variable. Bit clunky but it works.

Or this:

<cfset cols='red,blue,yellow'>
<cfquery datasource="datasource" name="name">
select #cols# from a_table
</query>

<cfloop query="name">
<cfloop list="#cols#" index="col">
<cfoutput>#name[col][name.currentrow]#</cfoutput>
</cfloop>
</cfloop>

Natomas wrote:
> There is a way to preserve the original order?
>


Yes, there is, but I do not know it.

If you don't have the original variable that formed the SQL statement,
you will need to do some searching. There is someway to do this.

You might explore this output a bit.

<cfset cols='red,blue,yellow'>
<cfquery datasource="datasource" name="name" result="george">
select #cols# from a_table
</query>

<cfdump var="#george#">

Fantastic.

One more question, the columnlist is alphabetically ordered. There is a way to preserve the original order?

Regards!

Natomas wrote:
> sorry, this line just gives me the column names (ie., red, blue, yellow). It does not display the data.

No it doesn't, but didn't it give you some ideas on how it might.

Of course unless you just want to dump the data. For that there is the
<cfdump var="#name#"> tag.

I presumed you would want some formatting of you your data. Here is a
larger hint on how that might be done.

<cfloop query="name">
<cfloop list="#name.columnlist#" index="col">
<cfoutput>#name[col][name.currentrow]#</cfoutput>
</cfloop>
</cfloop>

sorry, this line just gives me the column names (ie., red, blue, yellow). It does not display the data.

<cfoutput>#name.columnlist#</cfoutput>

See that doesn't give you any ideas.