The following code does something similar to what you want to do, but it
outputs it to the screen, but if you look youll see what it is you need I think:
<cfset variables.arResultsHeaders = ListToArray(variables.q.columnlist) />
<cfoutput>
<table align="left" id="queryResults">
<tr>
<th>
Row
</th>
<cfloop from="1"
to="#arrayLen(variables.arResultsHeaders)#" index="i">
<th>
#variables.arResultsHeaders[i]#
</th>
</cfloop>
</tr>
<cfloop from="1" to="#variables.q.recordCount#" index="k">
<tr>
<th>
#NumberFormat(k,"0000")#
</th>
<cfloop from="1"
to="#arrayLen(variables.arResultsHeaders)#" index="j">
<td>
#variables.q["#variables.arResultsHeaders[j]#"][k]#
</td>
</cfloop>
</tr>
</cfloop>
</table>
</cfoutput>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220812
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
