House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Mailing Lists
Home / Groups / ColdFusion Talk (CF-Talk)

Anyone see anything wrong with this code?

Author:
Rick Faircloth
05/01/2012 12:57 PM

Hi, all... I've just moved onto a new server and it seems that ever since that time, I've had problems getting this code to work. The code has been tweaked a lot, here, there, and everywhere over the last several days trying to figure out why it won't work. I can't give any clues on error messages, because this is part of a cfc on the back end of an ajax call. No errors show up in firebug or elsewhere. The breakdown the method occurs where this code begins. Prior to this code, data for a properly listing is inserted into a MySQL database...no problem. And, I should say that the code works through line 20, where the images are first written to the temp-images directory. The problem is that no files are written to the final directory and no entries are made into the table for the photos. This code has been running on another server for the last couple of years. (Plus the tweaks!) I had the temp directory outside the web root, but brought it inside the web root thinking that might be the problem, but it didn't help. I broke out the individual functions of this code and ran them locally and everything checked out locally, but combined and on the server, no go... Thanks for any feedback! Rick <cfquery  name = "qGetLastInsertID"  datasource = "myDatasource">      select     LAST_INSERT_ID() as propertyID      from       rentalProperties              </cfquery>              <cfset loopCounter = 1> <cfloop index="imageNumber" from="1" to="100" step="1">      <cfset imageFileField = '#imageNumber#_propertyPhoto' />      <cfif (StructKeyExists(FORM, imageFileField) AND Len(FORM[imageFileField]))>                         <cffile  action       =  "upload"               filefield    =  "#imageFileField#"               destination  = "e:\inetpub\webroot\holtzmanRentalsSiteManager\temp-images"               accept       =  "image/jpg, image/pjpg, image/jpeg, image/pjpeg, image/png"               nameConflict =  "makeUnique" />      <cfset    originalImageFileName = '#cffile.serverFileName#' />      <cfset    newImageFileName      = reReplace(#originalImageFileName#, [^a-zA-Z0-9_\-.], '', 'all') />      <cfset    originalImageExt      = '#cffile.serverFileExt#' />      <cfset    newFileNameComplete   = '#newImageFileName##originalImageExt#' />      <cfdirectory action      =  "list"                   directory  = "e:\inetpub\webroot\holtzmanRentalsSiteManager\temp-images"                   name        =  "image_list"  />      <cfif image_list.recordCount gt 0  >           <cfloop query = "image_list">                <cfif name is '#newFileNameComplete#'  >                     <cffile  action       = "rename"                              source       = "e:\inetpub\webroot\holtzmanRentalsSiteManager\temp-images\#newFileNameCompl ete#"                              destination  = "e:\inetpub\webroot\holtzmanRentalsSiteManager\temp-images\#newImageFileName #_#loopCounter##originalImageExt#">                     <cfset  renamedNewFileNameComplete = '#newImageFileName#_#loopCounter##originalImageExt#'/>                <cfelse>                     <cfset  renamedNewFileNameComplete = '#newFileNameComplete#'  />                </cfif>                <cfif isImageFile('e:\inetpub\webroot\holtzmanRentalsSiteManager\temp-images\#rena medNewFileNameComplete#')  >                     <cfimage  action       =  "resize"                               width        =  "200"                               height       =  ""                               source       = "e:\inetpub\webroot\holtzmanRentalsSiteManager\temp-images\#renamedNewFileNa meComplete#"                               destination   = "e:\inetpub\webroot\holtzmanRentals\user_images\photo200_#renamedNewFileName Complete#"                               overwrite    =  "true" />                     <cfset    photo200     = "photo200_#renamedNewFileNameComplete#">                     <cfimage  action       =  "resize"                               width        =  "75"                               height       =  "50"                               source       = "e:\inetpub\webroot\holtzmanRentalsSiteManager\temp-images\#renamedNewFileNa meComplete#"                               destination  = "e:\inetpub\webroot\holtzmanRentals\user_images\photo75x50_#renamedNewFileNa meComplete#"                               overwrite    =  "true"  />                     <cfset    photo75x50   = "photo75x50_#renamedNewFileNameComplete#"  />                     <cfimage  action       =  "resize"                               width        =  "458"                               height       =  "306"                               source       = "e:\inetpub\webroot\holtzmanRentalsSiteManager\temp-images\#renamedNewFileNa meComplete#"                               destination  = "e:\inetpub\webroot\holtzmanRentals\user_images\photo458x306_#renamedNewFile NameComplete#"                               overwrite    =  "true"  />                     <cfset    photo458x306 = "photo458x306_#renamedNewFileNameComplete#"  />                     <cffile   action       =  "delete"                               file         = "e:\inetpub\webroot\holtzmanRentalsSiteManager\temp-images\#renamedNewFileNa meComplete#"  />                     <cfquery  name = "qInsertPhotos" datasource="myDatasource">                                              insert                               into       rentalPhotos                                                           ( propertyID, photo200, photo75x50, photo458x306, photoOrder )                                  values     ( <cfqueryparam  cfsqltype = "cf_sql_int"      value = "#qGetLastInsertID.propertyID#"  >,                                            <cfqueryparam  cfsqltype = "cf_sql_varchar"  value = "#photo200#" >,                                            <cfqueryparam  cfsqltype = "cf_sql_varchar"  value = "#photo75x50#" >,                                            <cfqueryparam  cfsqltype = "cf_sql_varchar"  value = "#photo458x306#" >,                                            <cfqueryparam  cfsqltype = "cf_sql_int"      value = "#loopCounter#" >                                          )                        </cfquery>                                </cfif> <!--- [ cfif isImageFile ] --->                 <cfset loopCounter = loopCounter + 1 />             </cfloop> <!--- [ imageList name ] --->         </cfif> <!--- [ imageList.recordCount gt 0 ] --->                  </cfif> <!--- [ if structKeyExists, imageFileField ] ---> </cfloop> <!--- [ image 1 to 100 ] ---> <cfset addPropertyStruct.STATUS = 'Success' />            <cfreturn addPropertyStruct  />


Search cf-talk

May 21, 2013

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
       1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31   

Designer, Developer and mobile workflow conference