Extracting query information

[mickallen]

I'm trying to extract query information from a resultset, the problem is I don't know the column headings as the query is created by the user.
I can get the column headings using query.columnlist but can't seem to use this within a cfoutput query.

Is there anyway to extract the query results without knowing the column headings.

 

[csteinhilber]

Sure.
Something like:

<table border=&quot;1&quot;>
<tr>
    <CFLOOP list=&quot;#qryQueryName.ColumnList#&quot; index=&quot;sColumnName&quot;>
        <td><CFOUTPUT>#sColumnName#</CFOUTPUT></td>
    </CFLOOP>
</tr>
<CFOUTPUT query=&quot;qryQueryName&quot;>
    <tr>
        <CFLOOP list=&quot;#qryQueryName.ColumnList#&quot; index=&quot;sColumnName&quot;>
            <CFSET sColumnValue = qryQueryName[sColumnName]>
            <td>#sColumnValue#</td>
        </CFLOOP>
    </tr>
</CFOUTPUT>
</table>

-Carl

 

[r937]

"the query is created by the user"

you know about sql injection, right?

just asking...

rudy

http://r937.com/

 

[mickallen]

sorry for the delay in replying been away for a few days.
Thanks csteinhilber thats great.

r937 sorry but no I havn't heard of sql injection, what is it?

 

[r937]

http://google.com/search?q=sql+injection

rudy

 

[mickallen]

Thanks I'll have a look