You could use the "group" attribute of cfoutput. In your sql query, sort the
results by the [OrderNumber] column. Then group by [OrderNumber] in your
output.

<cfoutput query="yourQuery" group="OrderNumber">
<!---- each order number will be displayed only once --->
#OrderNumber#<br>

<cfoutput>
#ItemNumber#
<cfoutput>
</cfoutput>


http://livedocs.adobe.com/coldfusion...Tags_m-o_16.ht
ml