What's a better way to handle this?

[Rick Faircloth]

Hi, all...

I've got a database table of properties with mls numbers.
I've got a directory of photos.

I need to check and see if any of the photos names contain
the mls number of any of the properties, and, if so, copy the
matching photos to a new directory.

I tried querying the db for all mls numbers and also running
cfdirectory to get all the photo names.

Then I ran this code:

        <cfloop query='get_mls'>
                <cfloop query="photolist">
                        <cfif #listfirst(photolist.name, '_')# is 
#get_mls.mls_number#>
                                <cfoutput>#listfirst(photolist.name,
'_')#&nbsp;&nbsp;(#i#)</cfoutput><br>
                                <cfset i=i+1>
                        </cfif>
                </cfloop>
        </cfloop>

First problem:  request timeout
Solution:  <cfsetting requesttimeout = '60000'>

Second problem:  java.lang.OutOfMemoryError: Java heap space

What a more efficient way of handling this process, assuming
the approach above would even work?

Thanks for any help!

Rick


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306804
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4