<div>
<div class="content wysiwyg-content">
I am trying to figure out a way on how to display the output of a database query in coldfusion<br />
a bit different. Instead of having data displayed in rows and the columnheader is the field<br />
name, i want to have the field names in the rows and each record show be a seperate column.<br />
<br />
Like this<br />
<br />
User ID &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02<br />
Name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Tom &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Steve &nbsp; &nbsp; &nbsp; &nbsp; Mike<br />
Gender &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; M &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;M &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;M <br />
<br />
What is the best way to achieve this ?<br />
<br />
Thanks
</div>
</div>


I am trying to figure out a way on how to display the output of a database query in coldfusion
a bit different. Instead of having data displayed in rows and the columnheader is the field
name, i want to have the field names in the rows and each record show be a seperate column.

Like this

User ID           00               01              02
Name             Tom            Steve         Mike
Gender           M                M                M 

What is the best way to achieve this ?

Thanks

Build dynamic table output

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.