<div>
The basic steps are simple, but your approach will depends a lot on your current process, how the images are stored, total number of files, etc.. Conceptually:<br />
<br />
1. before the records are purged, run a query to grab properties that will be deleted. <br />
2. Loop through the property id's. For each one, use &lt;cfdirectory&gt; with a filter ie &nbsp;filter=&quot;IMG_#currentProper<wbr />tyID#*&quot; to locate the associated files. Then loop through the results and delete each file. Something along these lines (not tested)<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;cfloop query=&quot;deletedProperties&quot; ...&gt;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;cfdirectory action=&quot;list&quot; <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; directory=&quot;...&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; filter=&quot;IMG_#deletedProper<wbr />ties.prope<wbr />rtyID#*&quot; <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; type=&quot;file&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; listinfo=&quot;name&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; name=&quot;filesToDelete&quot; &nbsp;...&gt;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;cfloop query=&quot;filesToDelete&quot;&gt;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;cfset fullPath = filesToDelete.directory &amp;&quot;/&quot;&amp; filesToDelete.name&gt;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;cffile action=&quot;delete&quot; file=&quot;#fullPath#&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;/cfloop&gt;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/cfloop&gt;<br />
<br />
Keep in mind it won't scale well if you have a large number of images to delete OR a bunch of images all stored in a single directory. &nbsp;If that's the case, you may want to offload the cleanup process to a scheduled task. Run every X minutes and have the script process a batch of N items at a time (50,100, whatever...). That approach is more scalable and ensures the script won't timeout due to processing a massive number of files.<br />
<br />
Before you purge the properties, move the id's to a separate table, say PropertiesToDelete. When the script runs, grab the first N items:<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECT PropertyID FROM PropertiesToDelete LIMIT 50<br />
<br />
The loop through the id's and find the files (just like above). Only add a step - After the physical files are deleted - delete the propertyID record from the table - so it won't be processed again.<br />
<br />
HTH
</div>


<div>
Thanks, I like this approach. <br />
My problem is I do not know &nbsp;when these records will be deleted.<br />
The data is fed to my server and updated every 20 min.<br />
<br />
That is my challenge.. I need to: <br />
match the ID from the table to the file names,<br />
where &nbsp;'no matching ID' &nbsp;action &nbsp;delete file<br />
<br />
Does this make sense?<br />
Thanks!
</div>


<div>
(Method 1)<br />
Well ideally you want to compare the old and new data feeds to determine which property id's were deleted. &nbsp;Rather than just truncating and repopulating the table. Once you identify the deleted id's, the rest is simple. Example:<br />
<br />
Current Data ID's: 1,2,3,5,6,7<br />
New Data &nbsp;ID's: &nbsp; &nbsp; 1,5,6,8,14<br />
Deleted ID's: &nbsp; &nbsp; &nbsp; &nbsp; 2,3,7 &nbsp; &nbsp;&lt;=== removed<br />
<br />
I don't know how you're processing the new data, but typically you feed new data into a temp table. Then use JOIN's to identify new-changed-or deleted records. I remember posting an answer about something similar.. let me see if I can find it...<br />
<br />
(Method 2)<br />
Failing that, the only way to figure out which files to delete would be to compare all records in the db with all files on disk, and figure out what's missing. &nbsp;That could be Very time consuming since you have to examine *everything*. Best not to do that if you can avoid it. That sounds like what you're talking about below. ie Check all the files against all db records - and figure out which files to delete, ie<br />
<br />

<blockquote>
<br />
That is my challenge.. I need to:<br />
match the ID from the table to the file names,<br />
where &nbsp;'no matching ID' &nbsp;action &nbsp;delete file<br />

</blockquote>
<br />
Keep in mind you might need to do that <i>once</i> - just to get the ball rolling, but going forward it's better to do the detection - when the properties are removed ie Method 1. , instead of after the fact.
</div>


<div>
@izweig - Why the &nbsp;&quot;B&quot; grade? A &quot;B&quot; means the answer was incomplete. The answers provided above were very thorough given you only provided a general outline of your process. &nbsp;As I mentioned several times, to provide specific code - we need specific information about your process. ie &quot;How is your new data is imported, how many images, how they're stored etc.... &quot;. &nbsp;You should not assign B grades unless you've provided all of the necessary information and responded to all of the questions.
</div>


<div>
Does B mean incomplete?<br />
B means Good, according to the form, I thought your solution was good.<br />
Would you like an A?
</div>


<div>
It's more of an FYI. It may not very clear from the &quot;answer&quot; screen but generally <br />
<br />
&quot;A&quot; means =&gt; answered well<br />
&quot;B&quot; means =&gt; incomplete/partially answered <br />
&quot;C&quot; means =&gt; poorly answered. <br />
<br />
With most experts its a point of pride to provide solid and thorough answers. So a &quot;B&quot; grade is often seen as indicating they didn't fully answer the question. Sometimes it happens, but usually asker and expert exchange more questions until the expert has given them a complete answer they were satisfied with. <br />
<br />
(Edit) Again, it's a matter of perception ... (yes, we experts do take our fields seriously ;-) So just an FYI for future grading.
</div>


<div>
I see what you are saying. This is not clear in the grading form.
</div>


<div>
Yes, I spend more time answering than asking, so I'm not as familiar w/the answer form, but figured it's probably not as clear as it could be. &nbsp;(Edit) There used to be an FAQ on it. Not sure if it's still around after the redesign. &nbsp;Just figured I'd give you a heads up for the future. Anyway, thanks for responding :) &nbsp;Well back to the grind for me...
</div>


<div>
<div class="content wysiwyg-content">
I need help figuring out how to delete files in a folder that are no longer needed.<br />
They are image files, which relate to active real estate listings.<br />
When the listing is no longer active I wish to delete this images which are associated to the listing.<br />
My database table only has active listings, it doesn't not have old, deleted or expired.<br />
When my table gets updated (every 20 min) any non actives will be purged from the table, when this occurs I want to be able to delete the associated images from the server..<br />
<br />
the naming convention is:<br />
property id = propertyID<br />
Images = IMG_propertyID_1, IMG_propertyID_2, IMG_propertyID_3...<br />
<br />
<br />
Any help with this would be greatly appreciated.
</div>
</div>


I need help figuring out how to delete files in a folder that are no longer needed.
They are image files, which relate to active real estate listings.
When the listing is no longer active I wish to delete this images which are associated to the listing.
My database table only has active listings, it doesn't not have old, deleted or expired.
When my table gets updated (every 20 min) any non actives will be purged from the table, when this occurs I want to be able to delete the associated images from the server..

the naming convention is:
property id = propertyID
Images = IMG_propertyID_1, IMG_propertyID_2, IMG_propertyID_3...


Any help with this would be greatly appreciated.

Deleting (cffile) files where the related id does not exist- Coldfusion

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.

ColdFusion Language

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.