Remove files from an upload area
4 posts by 2 authors in: Forums > CMS Builder
Last Post: 10 hours ago (RSS)
By MercerDesign - June 25
Is it possible to remove ALL upload files from a multi list with one click of a button, I have a multi list that gets republished each week but we want to remove all files before they get republished because they get changed each week.
By Dave - Monday at 1:45pm
Hi MercerDesign,
Yes, it absolutely is, but be sure to back up and exercise caution when testing any code that has the potential to destroy data.
The line should do it:
// Remove ALL uploads from ALL records that match this criteria
removeUploads("tableName = 'yourTableName'");Hope that helps!
interactivetools.com
By MercerDesign - 10 hours ago
When I do a test on a new CMS table it works but when I try to implement this on an existing table I get this error: MySQL Error(1093): Error getting error record count: You can't specify target table 'cmsb__error_log' for update in FROM clause
Can you help please?