Thanks, but no. Same results. It makes me wonder what makes a group. Douglas Jordon wrote: > > Hi, > > I'm having trouble trying to group the results of a joined query: > > <cfquery datasource="vc" name="list"> > select server,names.id,fname,lname,role from accounts,names where > names.sid=accounts.sid > Order by LName,FName > </cfquery> > > The output code: > <cfoutput query="list" group="server"> > <tr><td><#server#</td></tr> > <cfoutput> > <TR> > <TD BGCOLOR=white>#LName#, #FName#</TD></TR> > </cfoutput> > </cfoutput> > > What I'm after: > > SERVER NAME > > Lastname Firstname > Lastname Firstname > Lastname Firstname etc > > But what i'm getting is: > > SERVER NAME > > Lastname Firstname > > SERVER NAME > > Lastname Firstname > > SERVER NAME > > Lastname Firstname etc. > > The only thing that's different from other queries I've grouped is that > this one is a join. > > TIA, > > Doug Jordon > ------------------------------------------------------------------------------ > Archives: http://www.mail-archive.com/[email protected]/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
