You need an inner cfoutput to loop inside the group. On 8/7/07, Peter Tanswell <[EMAIL PROTECTED]> wrote: > 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.
-- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285550 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
