My apologies Dave. This is what you get when you quickly scan the mail.
You are correct, I am wrong.
In cases like this, I defer to the person who is correct and reply from the
corner with a quiet "D'oh!"
:)
----- Original Message -----
From: "David Gassner" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 27, 2000 9:46 PM
Subject: RE: Suppressing Repeating Groups in a Query
> I don't see how Distinct would work in this case. If any value in a
record
> is unique, you'll get a record. The request was to suppress output of the
> repeating fields in columns 1 and 2 where a 3rd column's value changes on
> each record. If the 3rd column is unique in each record, you'll need to
> code the output in some fashion.
>
> > -----Original Message-----
> > From: John Cummings [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, October 27, 2000 6:30 PM
> > To: CF-Talk
> > Subject: Re: Suppressing Repeating Groups in a Query
> >
> >
> > Or as Brian said, just use SELECT DISTINCT FROM XXX
> > ----- Original Message -----
> > From: "David Gassner" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Friday, October 27, 2000 8:56 PM
> > Subject: RE: Suppressing Repeating Groups in a Query
> >
> >
> > > Sam, track the current value of the repeating field in a local
variable;
> > on
> > > each loop, check whether the repeating field value has changed,
> > and react
> > > accordingly:
> > >
> > > <cfset currentID = 0>
> > > <cfoutput query="myquery">
> > > <tr>
> > > <cfif myquery.ID is currentID> <!--- if it's repeated --->
> > > <td></td><td></td>
> > > <cfelse> <!--- if it's new --->
> > > <td>#myquery.id#</td><td>myquery.field2</td>
> > > <cfset currentID = myquery.ID>
> > > </cfif>
> > > <td>#myquery.statename#</td>
> > > </tr>
> > > </cfoutput>
> > >
> > > > -----Original Message-----
> > > > From: sam komolafe [mailto:[EMAIL PROTECTED]]
> > > > Sent: Friday, October 27, 2000 2:07 PM
> > > > To: CF-Talk
> > > > Cc: sam komolafe
> > > > 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]
> > >
> >
> > ------------------------------------------------------------------
> > ------------------------------
> > 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]
>
------------------------------------------------------------------------------------------------
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]