How to upload files with spaces: cffile adds underscores each time

This may be a simple question for the professional but I can't match the file name that is added to my Access database with the file name that is uploaded to the server when I use cffile do upload files that contain spaces between the words.

If the file name has spaces, the coldfusion server adds underscores between the spaces when it saves or uploads the file but when I update my Access database, the file name is preserved and does not contain underscores. This causes errors when the image or file is displayed dynamically.

How do I compensate for the underscores or prevent them from being added.

Thank You!

Paul Ikemire

I would strongly recommend that you don't use file names with spaces on the web in the first place. But as far as I know, there is no way to prevent cffile from adding the underscores. You'd have to try and rename the file yourself after the upload.