insert the file name into table after the file was uploaded to server folder

I tried to insert the image file's name after upload the file onto server folder successfully. Here is what I did. I uploaded the image file. I tried to insert the file name into the table. However, it did not work which means the file name is not stored in the image field in the table. Does somebody know how to do? I need the file name in the table to show the image later?

Assuming you have successfully uploaded the file using <cffile action="upload">, you can reference the uploaded filename as:

File.ServerFile

Given this, you just need to insert it into the database similar to this:

<cfquery name="insertIt">
INSERT INTO your_table
(filenameFieldInYourTable)
VALUES
('#File.ServerFile#')
</cfquery>

If you're already doing this, and you're getting an error, post your error here, along with your code.

Hey, It works only I need to modify something. But it is greate, it works. I appreciated!
Thanks!!!!!!!!