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>
Thanks for any help!