You need an inner <cfoutput
<cfoutput query="qGetCEProcedures" group="cecategory">
<cfoutput>
#qGetCEProcedures.cecategory#
<br />
<br />
#qGetCEProcedures.cename#
</cfoutput>
</cfoutput>
So you can put stuff in the first cfoutput or second, the first one happens
once per group and the second for each item in the group.
Regards
Dale Fraser
http://dalefraser.blogspot.com
-----Original Message-----
From: Peter Tanswell [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 7 August 2007 12:04 PM
To: CF-Talk
Subject: cfoutput and groups
Hi there
I have a query where I am getting information from 2 tables.
Basically a category table i.e. categories are face, body & breasts
Users have entered details of cosmetic enhancementprocedures according to
whether the procedure is for face, body or breasts, e.g. face has face lift,
rhinoplasty, browlift, Body has liposuction, tummy tuck etc
On the site I want to display the information in the respective groups hence
body, face and breasts.
My query is as follows:
SELECT cecat.cecatid, cecat.cecategory, ce.cecategoryid, ce.cename,
ce.cedetails, ce.ceresults
FROM tbl_cosmeticenhancement ce, tbl_cecategories cecat
WHERE ce.cecategoryid = cecat.cecatid
Order by cecat.cecategory
Then I was going to have
<cfoutput query="qGetCEProcedures" group="cecategory">
#qGetCEProcedures.cecategory# <br /> <br />
#qGetCEProcedures.cename#</cfoutput>
What I am finding is that I am only getting one result displayed for each
category instead of 3 or 4.
Thanks in advance for feedback.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285551
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
