Outputting a matrix table

[mikeandike]

Alright, I feel like this is easy, but I haven't been able to figure it out:

I have two database tables which I need to gather information from and output on a coldfusion page in a table.
I know I can output the data I need in a row with:

<cfquery name="list" datasource="abc">
select pkey, summary, stringvalue, numbervalue
from abc.issue.id=abc.customfieldvalue.issue
and project = 10200;
</cfquery>
<table>
<cfoutput query = "list">
<tr><td>#summary# : #list#</td></tr>
</cfoutput>
</table>

What I can't figure out is how to format this information into a table.

Thanks for any help!

[acoder]

Are you sure the query is correct? Have you checked the output in a database?

As for displaying in a table, first display the table headers outside the query loop and then within the cfoutput loop, put the fields in separate cells - you can't just use #list# to output all fields.