Upload DbClean with multiple files
Upload DbClean with multiple files
joshlevine102
Posts: 44Questions: 16Answers: 2
in Editor
Hey I tried adding a second column to my main table, so I now have file1 and file2 int columns which are foreign keys into the same files table. Is this the best practice for having a fixed number of file uploads? Should I use a separate file table for file2? Maybe using uploadMany and mjoin would be better. I'm running into the issue where if I try to use DbClean on both Upload fields, the DbClean for one field tries to delete the other field's files. Hope this makes sense. Thanks.
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
Yes you are right - the DbClean action isn't really well designed for this scenario at the moment.
Using the upload many field is probably the way to go, but it doesn't provide a hard limit on the number of files being uploaded.
Good idea for an enhancement though - thanks!
Allan
Allan, OK. Thanks. Good to know.