SELECT UpSellProductID from UpSells where ProductID = #ProductID# SELECT ProductID from UpSells where #ProductID# = UpSellProductID SELECT a.*, c.categoryid, d.name, b.DiscountType, b.DiscountAmount, b.DiscountEndDate, b.DiscountStartDate, (select count(productid) from OptionName where OptionName.ProductID = a.ProductID) AS optionCount FROM ((Products a LEFT JOIN Discounts b ON a.ProductID = b.ProductID) INNER JOIN ProductsCategories c ON a.ProductID = c.ProductID) INNER JOIN Categories d ON c.CategoryID = d.CategoryID WHERE a.productID in (#valueList(relatedItems.upSellProductID)#) OR a.productID in (#valueList(reverseRelatedItems.ProductID)#)
You may also like the following:
#htmlEditFormat(relateditemsDetail.Productname)#
SKU: #htmleditformat(ProductPartno)#

CF_EZCART ALERT!

Message: File includes/upsellRetailPrice.cfm is missing. Process aborted.

Consult your documentation for help.

Qty: Add to Order: SELECT a.name, a.nameid, a.required FROM OptionName a INNER JOIN OptionValue b ON (a.nameID = b.nameID) and (a.productid = b.productid) WHERE a.productid = #similarProductID# GROUP BY a.name, a.nameid, a.required SELECT * FROM OptionValue WHERE nameID = #getOptionsrelateditems.nameID# and Active = 1 ORDER BY valueID, value_desc
#getOptionsrelateditems.name#: