Thread: Coldfusion - Saving the File Name for Image Uploader Applet

I have recently purchased a Java Image Uploader from java upload applet - MyUploader does anyone have any coding that will allow me to save the image name in a MySQL db during or after a sucessful upload.

Any help would be great.

Just fyi, that sample is not a good example of well written CF code. I am not even sure it works. You would be better off using the livedocs example

http://livedocs.adobe.com/coldfusion...0.html#3540091

... or one of these guides.
http://www.coldfusionjedi.com/index....e-Upload-Guide
http://www.coldfusionjedi.com/index....Security-Issue

But, to answer your question about that specific example, you use <cffile..> to do the upload. CF then populates a structure named #CFFILE# (or the "result" attribute) with details like the fileName, extension, the directory it was saved to etctera. You can view all of file properties, by dumping the #CFFILE# structure just after your upload:

<cffile action="upload" ...>
<cfdump var="#CFFILE#">


You then use the #CFFILE# structure in combination with <cfquery ..> to extract and store the filename in your database.

<cfquery ...>
INSERT INTO SomeTable (SavedFileName)
VALUES ( <cfqueryparam value="#CFFILE.serverFile#" cfsqltype="cf_sql_varchar"> )
</cfquery>


Out of curiosity, why do you need a separate image uploader? ie What does it do that you cannot do with a regular form?

Thanks your prompt reply, I am relatively new to CF and have only been developing for the last year. I basically am looking to create a cfform that allows a user to upload up to 5 images, restricts file uploads to 2gb and stores the filename in the database, once uploaded the form action redirects the user to to a another page.

Any example coding instead of using Java to Work would be greatly apprecieted.

The Java image uploader from java upload applet MyUploader does anyone have any coding that will allow me to save the image name in a MySQL db during or after a sucessful upload.Thanks for sharing information.