Hi, Barry...sorry I took so long to get back to you...busy weekend. The code looks good as far as I can tell...the proof is always in the results.
You're now getting the correct filename in the db...are you also getting the image into the correct directory after uploading? Rick -----Original Message----- From: Barry Mcconaghey [mailto:[email protected]] Sent: Monday, December 14, 2009 10:55 AM To: cf-talk Subject: Re: Working With Images...Still looking Hello. I was able to upload an image and add it to my DB using CF8 and MySQl this weekend. Can somebody tell me if this is correct. There are no error messages and the DB is also correct. Thanks Barry <cfset thisDir = expandPath("images")> <!--- Determine whether the form is uploaded with the image. ---> <cfif IsDefined("image") AND image IS NOT "" and len(trim(form.image))> <!--- Determine whether the image file exceeds the size limits.---> <cfimage action="read" source="#form.image#" name="myImage"> <cfif myImage.width lt 100 or myImage.height lt 100 or myImage.width gt 1000 or myImage.height gt 1000> <cfthrow message="Please provide an image between 100 and 1000 pixels tall and wide."> <cflocation url="demo.cfm"> <cfelse> <!--- Use the cffile tag to upload the image file. ---> <cffile action="upload" fileField="image" destination="#thisDir#" result="fileUpload" nameconflict="makeunique" accept="image/jpeg,image/jpg,image/png"> <cfset newImageName = fileUpload.serverDirectory & fileUpload.serverFilename & fileUpload.serverFileExt> </cfif> </cfif> <!--- Insert into the database ---> <cfquery datasource="mydb"> INSERT INTO artists( image ) VALUES( '#fileUpload.serverFile#') </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329138 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
