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:285548 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
