Sam,
You could do this with groups example below.
Dan
<cfquery name="getstates" datasource="????">
select *
from tablename
order by field1, field2, field3
</cfquery>
<table>
<cfoutput group="field1" query="getstates">
<tr><td>#field1#</td><td>#field2#</td></tr>
<cfoutput>
<tr><td colspan=2>#field3#</td></tr>
</cfoutput>
</cfoutput>
----- Original Message -----
From: "sam komolafe" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Cc: "sam komolafe" <[EMAIL PROTECTED]>
Sent: Friday, October 27, 2000 5:06 PM
Subject: Suppressing Repeating Groups in a Query
> Hi guys,
>
> How do you suppress repeating groups in a query? e.g.
>
> What I Have:
> 1 DN12 California
> 1 DN12 Oregon
> 5 DQ46 Utah
> 5 DQ46 New York
> 9 DZ09 Texas
>
> What I Want:
> 1 DN12 California
> Oregon
> 5 DQ46 Utah
> Utah
> 9 DZ09 Texas
>
> Thanks
>
> --------------------------------------------------------------------------
----------------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]