Should be possible without doing another query. Simply work with your
list of recent product ids:
<!--- Get a list of all product ids from your cached query --->
<!--- If you wanted, you could cache this at the same time as the
query --->
<cfset AllProductIDs = ValueList(AllProducts.ProductID) />
<!--- Now loop over your list of recently viewed product ids --->
<cfloop list="#COOKIE.RecentlyViewed#" item="RecentItem">
<!--- Find the item in the list of all product ids --->
<cfset i = ListFind(AllProductIDs, RecentItem) />
<!--- Do whatever output you want for each recent product (if it's in
the list) --->
<cfif i gt 0>
Product ID: #AllProducts.ProductID[i]#
Product Name: #AllProducts.ProductName[i]#
ThumbNail: #AllProducts.ThumbNail[i]#
</cfif>
</cfloop>
(Code not tested, but should work fine).
Seb Duggan
Web & ColdFusion Developer
e: [EMAIL PROTECTED]
t: 07786 333184
w: http://sebduggan.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:315961
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
