Autoupdate a database of file info
Posted on 2001-06-27
I would like to know if there is a program or an easy way to do this...I have an IIS 5 FTP server, and files are uploaded constantly, I would like to have a bot or a program that monitors the files being written to a directory/drive and update a database of files already in it, it should monitor changes in file names and delete a record if the file is deleted and so forth.
So far its simple SQL statements being sent to the database, and its not hard reading file info such as path,file name, size, and in my case ID3 tags too. but having a program to autoupdate the process i can't seem to figure out.
Any ideas/help/solution would be greatly appreciated.