You could also use a query-of-queries with where biglistitem not in
(smalllistitems).
On 5/3/12 1:29 PM, Cameron Childress wrote:
> On Thu, May 3, 2012 at 12:10 PM, Les Mizzell<lesm...@bellsouth.net> wrote:
>
>> > convert your list to an array and loop over that
>>
>> The small list is the one that will have the operations done to it. The
>> large list is the one that I need to search for duplicate values. If the
>> server was running CF9 then I could use ArrayFind but that's not
>> available in CF8.
>
> Soooo.... You don't want to convert to an array and loop over that rather
> than a list?
>
> ArrayFind() is a shortcut for looping over an array, but you can also do
> that manually. Small lists aren't much of a problem, just big ones. So
> convert the long list to an array, or maybe even just use the query object
> from the DB on the long list. Leave the short list as is, it's unlikely to
> ever cause performance issues at 10 items.
>
> Psudocode:
>
> loop array=biglist
> {
> if (listFind(biglistItem,smalllist))
> {
> smalllist = listDeleteAt(smalllist, listFind(biglistItem,smalllist)));
> }
> }
>
> Now you have a de-duped small list.
>
> -Cameron
>
> ...
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350990
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
