Does anyone know how to check the filesize of a file which is uploaded as document. Many company’s still have a restriction on the file size of an attachment to be sent to them. I want to give a warning if the filesize exceeds a specific limit?
Page 1 / 1
SQL server has built-in function to read directory contents and show files and their sizes.
select * from sys.dm_os_enumerate_filesystem('C:\Thinkwise\GUI','*')
Thanks, I will try this.
When I do a file upload I cannot use the dm_os_enumerate_filesystem because the GUI is changing the path of the file directly into the ‘to-be-upload’ path.
My file upload has a file location. That’s mandatory on creating the domain.
The @file_upload field is directing to the new path. Not to the path I upload the file from. Since the file is not actually moved yet I cannot use the dm_os_enumerate because the file is not there yet!
I cannot retrieve the path where the file is uploaded from out of the form @parameters.
Ha any one a suggeston how to fix this?
I don’t know why but apparently the file_upload is checking the path from… So I’m now able to check the filesize when uploading a file