cfoutput query group - Cold Fusion

For starters, dont place <cfoutput></cfoutput> tags within an output query...
it wont work.

If you are going to have multiple instances of the same buyer with multiple
companies.. and you have to run it like this, I would suggest running a query
to return all of your results..

Then run an output query, and within the output query, run a query of queries
to select the supplier name based on the id/name passed in the output query.

This is a basic example, you'll have to rewrite to match your needs etc.

<cfoutput query="main_query">
<cfquery name="companies" dbtype="query">
select * from main_query
where name = '#buyer_name#' <--- I would use an id to be more specific
then a name --->
</cfquery>

<cfloop query="companies">
<tr>
<td>#buyer_name#</td>
<td>#buyer_number#</td>
<td>#supplier_name#</td>
<td align="center">#total_count#</td>
</tr>

</cfloop>

</cfoutput>

Actually, trojnfn's nesting of <cfoutput> was just fine, since the outer
<cfoutput> tag was using the group="" attribute.

When using the group attribute, you have to remember that everything inside
the outer <Cfoutput> block will only loop once per instance of the grouped
field. the code inside the inner <cfoutput> block will loop once for each
record in your query.

However, this may not be the best tool to use in this situation, since it
looks like you want multiple rows, but only display the name on the first row
for a given buyer. Maybe something like this might work better for you:

<!--- Used to store the current buyer name --->
<cfset sHoldName = "">
<cfoutput query="qryGet_Null">
<tr>
<!--- Only display the buyer name if the buyer name has changed since the
last record --->
<td><cfif buyer_name neq sHoldName>#buyer_name#<cfelse>&nbsp;</cfif></td>
<!--- Only display the buyer number if the buyer name has changed since
the last record --->
<td><cfif buyer_name neq sHoldName>#buyer_number#<cfelse>&nbsp;</cfif></td>
<!--- List supplier name and total_count for all rows --->
<td>#supplier_name#</td>
<td align="center">#total_count#</td>
<tr>
<!--- Store the buyer name for comparison against the next record --->
<cfset sHoldName = buyer_name>
<cfoutput>