This is a basic update page with the ability to change the file uploaded, or just leave the current one, or use none at all.
<cfif FORM.FileURL NEQ "">
<cfset FileURL = FILE.ClientFile>
<cfelseif FORM.CurrentFile NEQ "">
<cfset FileURL = #FORM.CurrentFile#>
<cfset FileURL = 'None Assigned' >
FileURL = '#FileURL#'
WHERE ID = '#FORM.ID#'
Hopefully you can see what I am trying to do. If a file field in "FileURL" exists, then use it, if not and something is in "CurrentFile", then use it, if neither of those, enter 'None Assigned'. So, I need it to work, even when no file was entered.