Professional Web Applications Themes

Help with deleting files NOT in DB.. - Coldfusion - Advanced Techniques

i have a database of file names that have been uploaded over the years. It was from an admin tool that allowed people to upload and manage images and flash files. The database stores the names of the files. pretty simple. However, when users uploaded files to replace existing ones, the old files were never removed and i need to clean up the directory as there are a massive amount of files that are not even being used. Basically i need to spit out the names of all the files from the database and compare them to all the files ...

Sponsored Links
  1. #1

    Default Help with deleting files NOT in DB..

    i have a database of file names that have been uploaded over the years. It was
    from an admin tool that allowed people to upload and manage images and flash
    files. The database stores the names of the files. pretty simple. However, when
    users uploaded files to replace existing ones, the old files were never removed
    and i need to clean up the directory as there are a massive amount of files
    that are not even being used.

    Basically i need to spit out the names of all the files from the database and
    compare them to all the files in the directory. If the file name IS NOT in the
    DB, delete it.

    Not sure where to start on this one and any help would be greatily appreciated.

    Sponsored Links
    peterlevin Guest

  2. #2

    Default Re: Help with deleting files NOT in DB..

    I would convert my query to a list of files (file1,file2,file23...) and then
    use cffile to loop over the list of files in the directory... on each loop
    iteration I would run a listFind to see if that file is my list from the DB...
    if not, delete the file.


    ScottyMTL Guest

  3. #3

    Default Re: Help with deleting files NOT in DB..

    thanks for the insight. figured it out...
    peterlevin Guest

Similar Threads

  1. Deleting Exe files
    By wasowerby in forum Macromedia Contribute Connection Administrtion
    Replies: 3
    Last Post: September 30th, 07:14 AM
  2. Deleting .flv Files
    By Khuffie in forum Macromedia Flash Flashcom
    Replies: 1
    Last Post: April 8th, 10:22 PM
  3. need . deleting files
    By Nicholas in forum Windows XP/2000/ME
    Replies: 2
    Last Post: August 7th, 02:54 AM
  4. deleting files
    By Mark in forum Windows Setup, Administration & Security
    Replies: 1
    Last Post: July 29th, 12:14 PM
  5. deleting .dll files
    By Sanford in forum Windows Setup, Administration & Security
    Replies: 0
    Last Post: July 1st, 02:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139