Hi Peter,
Here's one way to do this:
<cfquery name="myquery"...>
SELECT f.food_id, n.value, n.nutrient
FROM nip_food f, nip_nutrient n
WHERE f.food_id = n. food_id
ORDER BY f.food_id, n.nutrient
</cfquery>
<cfoutput query="myquery" group="food_id">
<p>
#food_id#
<table>
<tr>
<cfoutput><th>#nutrient#</th></cfoutput>
</tr>
<tr>
<cfoutput><td>#value#</td></cfoutput>
</tr>
</table>
</p>
</cfoutput>
Make sense?
-d
Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
