<cfloop query="whatever"> <cfimage source="#large#\#imgname#" name="objImage" action="read" /> <cffile action="delete" file="#large#\#imgname#" > <!--- get the image filename ---> <cfquery name="getimgs" datasource="#client.datasource#"> select title from gallery where imgid = '#id#' </cfquery> <cfquery name="update_large" datasource="#client.datasource#"> UPDATE gallery SET image = '#imgname#' where imgid = '#id#' </cfquery>
<cfif objImage.width gt 1200> <cfset ImageScaleToFit(objImage,1200,1200,"highestPerformance")> <cfimage overwrite="yes" action="write" source="#objImage#" destination="#large#\#imgname#" format="jpg" /> <cfelse> <cfimage overwrite="yes" action="write" source="#objImage#" destination="#LargeDir#\#imgname#" format="jpg" /> </cfif> </cfif> <cfif isImage(objImage)> <cfif objImage.width gt 700> <cfset ImageScaleToFit(objImage,700,700,"highestPerformance")> </cfif> <cfimage overwrite="yes" action="write" source="#objImage#" destination="#LargeDir##id#.jpg" format="jpg" /> <cfset ImageScaleToFit(objImage,150,150,"highestPerformance")> <cfimage overwrite="yes" action="write" source="#objImage#" destination="#ThumbDir##id#.jpg" format="jpg" /> <!--- scale to flash size ---> <cfset ImageScaleToFit(objImage,75,75,"highestPerformance")> <!--- crop to center ---> <cfif objImage.width gt objImage.height> <cfset imageCrop(objImage,12.5,0,50,50)> <cfelse> <cfset imageCrop(objImage,0,12.5,50,50)> </cfif> <cfimage overwrite="yes" action="write" source="#objImage#" destination="#FlashDir##id#.jpg" format="jpg" /> </cfloop> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317633 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4