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:329137 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4