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 />
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350918
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
