Help with variable query?

[Bukzor]

I'm having an arbitrary query input by the user, then to make that query into
an excel file it must be put into a table similar to below. Since I don't know
the number of columns necessarily i use ListLen(), and since I don't
necessarily know the names of all the colums i use <cfloop>. I am able to put
all the names of the columns into an excel file in this way (by using "i"
instead of "OSFAres.i").

Basically all of this works except the part with "OSFAres.i". An error is
thrown "no member i exists of query OSFAres" even though "i" should hold the
name of one of the columns. Basically I need to find a way to force the server
to evaluate i before it evaluates OSFAres.i.



<table cols="#ListLen(OSFAres.ColumnList)#">
<cfoutput query="OSFAres">
<tr>
<cfloop LIST="#OSFAres.ColumnList#" index="i">
<td>#OSFAres.i#</td>
</cfloop>
</tr>
</cfoutput>
</table>

[gwgiswebmaster]

<cfloop LIST='#OSFAres.ColumnList#' index='i'>
<td>#i#</td>
</cfloop>

[Bukzor]

gwgiswebmaster:

That does does run without error, but it puts the titles of the columns in the table, not the data from the query.

[gwgiswebmaster]

sorry, misunderstood exactly what you were going for, try this: <cfoutput>
<table> <tr> <cfloop LIST='#OSFAres.ColumnList#' index='i'>
<td>#i#</td> </cfloop> </tr> <cfloop query='OSFAres'> <tr> <cfloop
LIST='#OSFAres.ColumnList#' index='i'> <td>#Evaluate('OSFAres.' &amp;
i)#</td> </cfloop> </tr> </cfloop> </table> </cfoutput>

[Bukzor]

thankyou thankyou

exactly what i was looking for :)