I have a problem with over flow images.
How can I remove images that belongs to an inactive user from my folder.
so, if the user have an ad online and his/her membership expired or their membership is set to inactive. I need to remove all their images that are stored in my server folder. Otherwise I will have tones of pictures stored.
In my database I have a path stored to the images.
<cfif len(SmlPathImage1) and fileExists(expandPath(SmlP
My folder name is "LoadImages "
this will delete all ads that belong to the inactive users
Delete from ADS
where UserID in (select UserTbl.UserID
where UserTbl.UserStatus = "I")