RE: Ignoring duplicates in Nathan R. Jessop Thu, 20 May 2004 11:57:15 -0700 I don't want to use a database because of oeverhead. On Thu, 20 May 2004 14:48:18 -0400, Philip Arnold wrote: >Order the list in SQL, then use a CFOUTPUT GROUP to ensure that they're >unique > >> -----Original Message----- >> From: Nathan R. Jessop [mailto:[EMAIL PROTECTED] >> Sent: 20 May 2004 14:12 >> To: CF-Talk >> Subject: re: Ignoring duplicates in <select> >> >> >> Sorry...forgot a subject line. >> >> ==================BEGIN FORWARDED MESSAGE================== >> >From: "Nathan R. Jessop" <[EMAIL PROTECTED]> >> >To: "Bushy" <[EMAIL PROTECTED]> >> >Date: Thu, 20 May 2004 14:09:56 -0400 >> >Reply-To: "Nathan R. Jessop" <[EMAIL PROTECTED]> >> >Priority: Normal >> >X-Mailer: PMMail 2000 Standard (2.20.2502) For Windows 2000 >> >(5.1.2600;1) >> >MIME-Version: 1.0 >> >Content-Type: text/plain; charset="iso-8859-1" >> >Content-Transfer-Encoding: 7bit >> >Subject: >> > >> >> >> Hi, >> >> I have a listing <select> listing thats been generated by a >> <cfloop>. A sample of the output would look like this: >> >> Seq: 1 Folio: 2201 >> Seq: 2 Folio: 2202 >> Seq: 3 Folio: 2203 >> Seq: 4 Folio: 2204 >> Seq: 5 Folio: 2205 >> Seq: 6 Folio: 2201 >> Seq: 7 Folio: 2202 >> Seq: 8 Folio: 2203 >> Seq: 9 Folio: 2204 >> Seq: 10 Folio: 2205 >> >> My question is. Whats the easist way to get the listing to >> display only the following: >> Seq: 1 Folio: 2201 >> Seq: 2 Folio: 2202 >> Seq: 3 Folio: 2203 >> Seq: 4 Folio: 2204 >> Seq: 5 Folio: 2205 >> >> and ignore any duplicate Folios? The <option> tag below >> generates the listing with the <cfloop> >> >> Can I easily wrap a <cfif> statement around the <option> tag? >> >> >> >> <select name="filelistselect" size="15" multiple > >> <cfloop INDEX="i" FROM="1" TO="#ArrayLen(arPages)#"> >> <option value="#sValNoComma#">Seq: >> #sValNoComma#&nbsp;&nbsp;Folio: #sDisp##spacer1#</option> >> </cfloop> >> </select> >> >> >> >> >> --------------------------------------------------- >> Colonel Nathan R. Jessop >> Commanding Officer >> Marine Ground Forces >> Guatanamo Bay, Cuba >> --------------------------------------------------- >> >> >> >> ===================END FORWARDED MESSAGE=================== >> >> >> >> --------------------------------------------------- >> Colonel Nathan R. Jessop >> Commanding Officer >> Marine Ground Forces >> Guatanamo Bay, Cuba >> > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] Previous message View by thread View by date Next message re: Ignoring duplicates in <select> Nathan R. Jessop RE: Ignoring duplicates in <select> Philip Arnold RE: Ignoring duplicates in <select> Nathan R. Jessop RE: Ignoring duplicates in <select> Philip Arnold RE: Ignoring duplicates in <select>... Nathan R. Jessop RE: Ignoring duplicates in <select> d.a.collie RE: Ignoring duplicates in <select> Nathan R. Jessop RE: Ignoring duplicates in <select> Adkins, Randy RE: Ignoring duplicates in <select> Nathan R. Jessop RE: Ignoring duplicates in <select> Philip Arnold RE: Ignoring duplicates in <select> Adkins, Randy RE: Ignoring duplicates in <select> d.a.collie Re: Ignoring duplicates in <select> d.a.collie Reply via email to

[Nathan R. Jessop]

I don't want to use a database because of oeverhead.

On Thu, 20 May 2004 14:48:18 -0400, Philip Arnold wrote:

>Order the list in SQL, then use a CFOUTPUT GROUP to ensure that they're
>unique
>
>> -----Original Message-----
>> From: Nathan R. Jessop [mailto:[EMAIL PROTECTED]
>> Sent: 20 May 2004 14:12
>> To: CF-Talk
>> Subject: re: Ignoring duplicates in <select>
>>
>>
>> Sorry...forgot a subject line.
>>
>> ==================BEGIN FORWARDED MESSAGE==================
>> >From: "Nathan R. Jessop" <[EMAIL PROTECTED]>
>> >To: "Bushy" <[EMAIL PROTECTED]>
>> >Date: Thu, 20 May 2004 14:09:56 -0400
>> >Reply-To: "Nathan R. Jessop" <[EMAIL PROTECTED]>
>> >Priority: Normal
>> >X-Mailer: PMMail 2000 Standard (2.20.2502) For Windows 2000
>> >(5.1.2600;1)
>> >MIME-Version: 1.0
>> >Content-Type: text/plain; charset="iso-8859-1"
>> >Content-Transfer-Encoding: 7bit
>> >Subject:
>> >
>>
>>
>> Hi,
>>
>> I have a listing <select> listing thats been generated by a
>> <cfloop>. A sample of the output would look like this:
>>
>> Seq: 1  Folio: 2201
>> Seq: 2  Folio: 2202
>> Seq: 3  Folio: 2203
>> Seq: 4  Folio: 2204
>> Seq: 5  Folio: 2205
>> Seq: 6  Folio: 2201
>> Seq: 7  Folio: 2202
>> Seq: 8  Folio: 2203
>> Seq: 9  Folio: 2204
>> Seq: 10  Folio: 2205
>>
>> My question is. Whats the easist way to get the listing to
>> display only the following:
>> Seq: 1  Folio: 2201
>> Seq: 2  Folio: 2202
>> Seq: 3  Folio: 2203
>> Seq: 4  Folio: 2204
>> Seq: 5  Folio: 2205
>>
>> and ignore any duplicate Folios? The <option> tag below
>> generates the listing with the <cfloop>
>>
>> Can I easily wrap a <cfif> statement around the <option> tag?
>>
>>
>>
>> <select name="filelistselect" size="15" multiple >
>> <cfloop INDEX="i" FROM="1" TO="#ArrayLen(arPages)#">
>> <option value="#sValNoComma#">Seq:
>> #sValNoComma#&nbsp;&nbsp;Folio: #sDisp##spacer1#</option>
>> </cfloop>
>> </select>
>>
>>
>>
>>
>> ---------------------------------------------------
>> Colonel Nathan R. Jessop
>> Commanding Officer
>> Marine Ground Forces
>> Guatanamo Bay, Cuba
>> ---------------------------------------------------
>>
>>
>>
>> ===================END FORWARDED MESSAGE===================
>>
>>
>>
>> ---------------------------------------------------
>> Colonel Nathan R. Jessop
>> Commanding Officer
>> Marine Ground Forces
>> Guatanamo Bay, Cuba
>>
>
>

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---