Retain NULL database value with blank file upload.
I have a form that inserts data into a database which also includes 3 'File Upload' behaviours. These behaviours sends the 'Server file name' to its appropriate column. Incidentally all three file name columns have a default value of NULL. Not all three 'File Upload' behaviours are always used. A small issue thats annoying me is if any of the file uploads are not used, when the data is inserted into the database the NULL value is cleared.
Can this be prevented for consistency in the database?
Thanks in advance!
Steve