If my imput file list looks likes this (arrows just indicate extra folios)
001>folio: 2201 . . . 274.00 points free
002>folio: 2251 . . . 021.00 points free
003>folio: 2252 . . . 001.00 points free
004>folio: 2253 . . . 011.00 points free
005>folio: 2254 . . . 001.00 points free
006>folio: 2201 . . . 006.50 points free
007>folio: 2202 . . . 006.50 points free <--
008>folio: 2203 . . . 006.50 points free <--
009>folio: 2251 . . . 230.50 points free
0010>folio: 2252 . . . 000.00 points free
011>folio: 2253 . . . 001.00 points free
010>folio: 2254 . . . 202.50 points free
When I run it through the code I get this:
001>folio: 2201 . . . 006.50 points free
002>folio: 2251 . . . 230.50 points free
003>folio: 2252 . . . 000.00 points free
004>folio: 2253 . . . 001.00 points free
005>folio: 2254 . . . 202.50 points free
006>folio: 2202 . . . 006.50 points free <--
007>folio: 2203 . . . 006.50 points free <--
How can I get it to output in the correct order?
>>> -----Original Message-----
>>> From: Nathan R. Jessop [mailto:[EMAIL PROTECTED]
>>> Sent: 21 May 2004 09:32
>>> To: CF-Talk
>>> Subject: Re: Ignoring duplicates in <select>
>>>
>>>
>>> It's now displaying my list but its still duplicating. I
>>> think it has something to do with the extra lines of code
>>> that I stripped out before I posted this.
>>>
>>> Something is conflicting. I'm reading in an external file
>>> that looks like this:
>>>
>>> 001>folio: 2201 . . . 274.00 points free
>>> 002>folio: 2251 . . . 021.00 points free
>>> 003>folio: 2252 . . . 001.00 points free
>>> 004>folio: 2253 . . . 011.00 points free
>>> 005>folio: 2254 . . . 001.00 points free
>>> 006>folio: 2201 . . . 006.50 points free
>>> 007>folio: 2251 . . . 230.50 points free
>>> 008>folio: 2252 . . . 000.00 points free
>>> 009>folio: 2253 . . . 001.00 points free
>>> 010>folio: 2254 . . . 202.50 points free
>>>
>>> Here is ALL the code in the <CFLOOP>
>>>
>>> <cfset noDupList = "">
>>> <cfloop INDEX="i" FROM="1" TO="#ArrayLen(arPages)#">
>>> <cfset sValNoComma = arPages[i]>
>>> <cfset sVal = Trim(ListFirst(arPages[i], ">"))>
>>> <cfset sDisp = Trim(ListLast(arPages[i], ">"))>
>>> <cfset sValNoComma = NumberFormat(sVal, "9999999999")>
>>> <cfset sVal = NumberFormat(sVal)>
>>> <cfif not listFindNoCase(noDupList, sValNoComma)>
>>> <cfset noDupList = listAppend(noDupList,sValNoComma)>
>>> <option value="#sValNoComma#">Seq:
>>> #sValNoComma# Folio: #sDisp##spacer1#</option>
>>> </cfif>
>>> </cfloop>
>>>
>>> This is the output I'm getting now:
>>>
>>> Seq: 1 Folio: 2201
>>> Seq: 2 Folio: 2251
>>> Seq: 3 Folio: 2252
>>> Seq: 4 Folio: 2253
>>> Seq: 5 Folio: 2254
>>> Seq: 6 Folio: 2201
>>> Seq: 7 Folio: 2251
>>> Seq: 8 Folio: 2252
>>> Seq: 9 Folio: 2253
>>> Seq: 10 Folio: 2254
>>>
>>>
>>> I want it to about like this. Ignoring the duplicates:
>>>
>>> Seq: 1 Folio: 2201
>>> Seq: 2 Folio: 2251
>>> Seq: 3 Folio: 2252
>>> Seq: 4 Folio: 2253
>>> Seq: 5 Folio: 2254
>>>
>>> On Fri, 21 May 2004 14:26:19 +0100, [EMAIL PROTECTED] wrote:
>>>
>>> >Oops as Philip said it would need to be
>>> >
>>> ><cfset noDupList = "">
>>> ><CFLOOP from="1" to="#ArrayLen(arPages)#" index="i">
>>> > <cfset sValNoComma = arPages[i]>
>>> > <cfif not listFindNoCase(noDupList, sValNoComma)>
>>> > <cfset noDupList = listAppend(noDupList,sValNoComma)>
>>> > <option value="#sValNoComma#">Seq:
>>> >#sValNoComma# Folio: #sDisp##spacer1#</option>
>>> > </cfif>
>>> ></CFLOOP>
>>> >
>>> >was more concerned with what was going on in the loop rats :-)
>>> >
>>> >--
>>> >dc
>>> >
>>> >
>>> >
>>> >
>>>
>>>
>>
>>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
