joined query and grouping

[Douglas Jordon]

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/cf-talk@houseoffusion.com/
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.