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/#itemThumbnail#"
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 - New Atlanta
http://www.newatlanta.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188452
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=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
