value from colmunlist

[twcman]

How can I make this work:

<cfloop index=&quot;i&quot; list=&quot;#testq.columnlist#&quot; delimiters=&quot;,&quot;>
<cfoutput>#i# = #Evaluate(tesq.i)#<BR></cfoutput>

</cfloop>

I am trying to display the name of a field and the value. I am having trouble figuring out how to display tesq.i.


thanks The only dumb questions are the ones that are never asked

 

[tleish]

Try:

[COLOR=666666]<!--- This will just return just the first record in the query --->[/color]
<cfset row = 1>
<cfloop list=&quot;#testq.columnlist#&quot; index=&quot;c&quot;>
<cfoutput>#c# = #testq

[

c

]

[

row

]

#[COLOR=000080]<BR>[/color]</cfoutput>
</cfloop>
[COLOR=000080]<BR>[/color][COLOR=000080]<BR>[/color]

[COLOR=666666]<!--- This will just return all Records from query --->[/color]
<cfloop query=&quot;testq&quot;>
<cfset row = testq.CurrentRow>
<cfloop list=&quot;#testq.columnlist#&quot; index=&quot;c&quot;>
<cfoutput>#c# = #testq

[

c

]

[

row

]

#[COLOR=000080]<BR>[/color]</cfoutput>
</cfloop>
[COLOR=000080]<BR>[/color][COLOR=000080]<BR>[/color]
</cfloop> - tleish