You could proceed as follows:

1) Create a database table named uploadedFile. The columns could be, for example,

upload_id: INT, autoincrement, primary key

datetimecreated: DATETIME

serverfile: VARCHAR(50)

serverdirectory: VARCHAR(30)

2) Do your multi-upload, for example,

myMultiUploader.cfm

<cffileupload url="myUploadFiles.cfm" width="600" ... etc>

myUploadFiles.cfm

<cffile action = "uploadAll" destination = "c:\myUploads" nameConflict = "overwrite">

<!--- This is where your question gets answered --->   

<!--- All the information about each uploaded file is stored in the cffile structure. ColdFusion creates one cffile struct for each and every file you upload in a single upload round --->

<!--- Save the information about each file to the database. The back slash \ often serves the purpose of an escape character. So I've replaced it with the forward slash / in the file path. --->

<cfquery name="saveUploadInfo" datasource="myDSN">

    insert into uploadedfile (datetimecreated, serverdirectory, serverfile)

    values (#cffile.timecreated#, '#replace(cffile.serverdirectory,"\","/","all")#', '#cffile.serverfile#')

</cfquery>

<!--- You could in fact log (and review) all the upload data by means of the following --->

<!--- <cflog file="uploadData" text="#serializeJson(cffile)#"> --->

btvbillb wrote:

 

To display my uploaded files on a page where the files can appear as links or be deleted, how would I get only the uploaded files to display for each record in the database?

For example, make sure the upload directory is under the web root, something like: c:\ColdFusion9\wwwroot\myUploads. then you've already solved half the problem. The rest can proceed as follows (using my query above as example)

<cfquery name="getUploadFiles" datasource="myDSN">

    select serverfile

    from uploadedfile

    where datetimecreated > #some_datetime_value#

</cfquery>

List of links: <br>

<cfif getUploadFiles.recordcount GT 0>

<cfoutput query="getUploadFiles" >

http://127.0.0.1:8500/myUploads/#serverfile#<br>

</cfoutput>

</cfif>

Also, where would the log file "uploadData" log file be created/generated?

c:\ColdFusion9\logs