> <cfif not listFindNoCase(noDupList, sValNoComma)>
> <cfset noDupList = listAppend(noDupList,sValNoComma)>
Should be
> <cfif not listFindNoCase(noDupList, sDisp)>
> <cfset noDupList = listAppend(noDupList,sDisp)>
> -----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]
