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:

Expand|Select|Wrap|Line Numbers

 <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.

Outputting a matrix table

re: Outputting a matrix table

Similar ColdFusion bytes

/bytes/development

/bytes/it

/bytes/about