I'm not entirely sure what you're trying to do. what should the expected output look like? AFAIK, to use the Group attribute in CFOutput properly, you need to have ordered by that field(s) in your query.
Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- Dave Phipps <dave@phipps- To: <[EMAIL PROTECTED]> cf.co.uk> cc: Subject: Re: [ cf-dev ] grouping output problem 01/23/03 03:35 PM Please respond to dev The query is as follows: <cfquery name="journoDetails" datasource="#request.dsn#" dbtype="ODBC"> SELECT journoDetails.journoid, journoDetails.journoName, journoDetails.journoTel, journoDetails.journoEmail, journoDetails.journoMediaTitle, journoDetails.journoPword, journoDetails.isNational, region.regionid, region.region, towns.townid, towns.town, journoRoles.role, journoRoles.journoRolesid, natOption.natOptid, natOption.natOpt FROM journoDetails LEFT JOIN journoRegion ON journoDetails.journoid = journoRegion.journoid LEFT JOIN region ON journoRegion.regionid = region.regionid LEFT JOIN journoTown ON journoDetails.journoid = journoTown.journoid LEFT JOIN towns ON journoTown.townid = towns.townid LEFT JOIN journoRoles ON journoDetails.roleid = journoRoles.journoRolesid LEFT JOIN journoNatOpt ON journoDetails.journoid = journoNatOpt.journoid LEFT JOIN natOption ON journoNatOpt.natOptid = natOption.natOptid WHERE journoDetails.journoid ='#attributes.journoid#' </cfquery> Thanks Dave At 15:31 1/23/2003 +0000, you wrote: >what's the query? > > >Duncan Cumming >IT Manager > >http://www.alienationdesign.co.uk >mailto:[EMAIL PROTECTED] >Tel: 0141 575 9700 >Fax: 0141 575 9600 > >Creative solutions in a technical world > >---------------------------------------------------------------------- >Get your domain names online from: >http://www.alienationdomains.co.uk >Reseller options available! >---------------------------------------------------------------------- >---------------------------------------------------------------------- > > > > > Dave > Phipps > > <dave@phipps- To: ColdFusion User group > <[EMAIL PROTECTED]> > cf.co.uk> cc: > > Subject: [ cf-dev ] grouping > output problem > 01/23/03 > > 03:27 > PM > > Please > > respond > to > > dev > > > > > > > > > > >Hi, > >I am trying to group some output from a query and I can only seem to some >of it to group properly > >I have the following output: > ><cfoutput query="journoDetails" group="journoid"> > <cfif journoDetails.region IS NOT ""> > <td class="normal" valign="top"><cfoutput >group="regionid">#journoDetails.region#<br></cfoutput></td> > </cfif> > <cfif journoDetails.town IS NOT ""> > <td class="normal" valign="top"><cfoutput >group="townid">#journoDetails.town#<br></cfoutput></td> > </cfif> > <cfif journoDetails.isNational EQ 1> > <td class="normal" valign="top"> > National (Options: <cfif journoDetails.natOpt IS >NOT "">(<cfoutput group="natOptid"> >#journoDetails.natOpt#</cfoutput>)<cfelse>None specified.</cfif>) > </td> > </cfif> ></cfoutput> > >With my test query I get 4 results for a particular journoid and this above > >code gives something like: > >Region: Buckinghamshire<br>Oxfordshire >Town: Chipping Norton<br>Oxford<br>Chipping Norton<br>Oxford > >What I want of course is for only the two regions and two towns to be >listed. I have tried ordering the query and this causes region to be >duplicated. > >Any help or ideas of a workaround? > >Thanks > >Dave > > >-- >** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >For human help, e-mail: [EMAIL PROTECTED] > > > > > > >-- >** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >For human help, e-mail: [EMAIL PROTECTED] ============================================ Phipps CF Development Oxford, Oxfordshire. Telephone: +44(0)7718 896696 http://www.phipps-cf.co.uk ============================================ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
