Well, the date/time stuff is backwards. TheTime uses Dateformat and theDate uses Timeformat. You didn't really give much other details as to what doesn't work. View the source and see what the path for the images is and compare it to what the image path should be, then make the necessary changes. Check the variable of request.relRootPath and make sure that's what it should be.
John Burns Certified Advanced ColdFusion MX Developer AI-ES Aeronautics, Web Developer -----Original Message----- From: Jason Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 21, 2004 3:03 PM To: CF-Talk Subject: Image Thumbnails I have a piece of code that works fine but from the switch from access to mysql now a lot of the images do not display. <!--- GET LATEST 5 INVENTORY ITEMS SET THE DATE/TIME VARIABLE FOR SEARCHING ---> <cfset theDate = TimeFormat(now(), "HH:MM:SS")><cfset theTime = DateFormat(now(), "YYYY/MM/DD")> <cfif not isDefined('iCache')> <cfquery name="getTopFiveItemsByDate" datasource="#DS#" maxrows="5" cachedwithin="#CreateTimeSpan(0,1,0,1)#" ><!--- cachedafter="#CreateTimeSpan(0,0,1,0)#" ---> SELECT itemID, itemName, itemKeywords, itemThumbnail FROM tblItem, tblkItemStatus WHERE tblItem.itemStatusID = tblkItemStatus.itemStatusID AND tblkItemStatus.itemStatusMainID = 2 ORDER BY dataEntryDate DESC, dataEntryTime DESC LIMIT 5 </cfquery> </cfif> <!--- TITLE---> <table> <cfif not isDefined('iCache')> <tr> <td><cfoutput><img src="#Request.RelRootPath#zimages/rm_fiveNewestItems.gif" alt="Great Deals on Used Equipment" title="Search Our Inventory"/></cfoutput></td> </tr> <tr> <td class="rightMenu" style="padding-top: 4px; text-align: left; font: bold 9px; padding-left: 2px;"> <table style="padding: 1px 0px 1px 0px;"> <cfset iCount = 1> <cfoutput query="getTopFiveItemsByDate"> <tr> <td><a href="#Request.RelRootPath#search/itemDetail.cfm?itemID=#itemID#" title="View Details of #itemName#" class="rightMenu" style=" color: ##006699; "><span style="padding: 0px 2px 0px 2px; color: ##006699; border: 2px ##006699 solid; border-left: 1px ##006699 solid; background-color:##FFCC00; "><cfif isDefined('itemThumbnail') and itemThumbnail neq " "><img src="#Request.RelRootPath#zimages/uploadedItemImages/thumbnail/#itemThum bnail#" width="30px" alt="#itemKeywords#" /><cfelse>#iCount#</cfif></span></a></td> <td><a href="#Request.RelRootPath#search/itemDetail.cfm?itemID=#itemID#" title="View Details of #itemName#" class="rightMenu" style=" color: ##006699; "><strong>#itemName#</strong></a><span style="font-size:2px;"><br><br</span></span></td> <cfset iCount = iCount + 1> </tr> </cfoutput> </table> </td> </tr> </cfif> Can anyone just scan over that code for me my eyes can't find any problems but where a image should be loading if you right click and check properties the image name isn't showing up. Now since this is just the code to display the top 5 items I'm assuming this error could be anywhere between the adding of the image file to the thumb nailing of the image. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188453 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
