CF_eConstruct ALERT!

Message: Value invalid for attribute, #param#.

Possible Values are:
  • Yes
  • No
Consult your documentation for help.

CF_eConstruct ALERT!

Message: File eConstruct_appGlobals.cfm is missing. Process aborted.

Consult your documentation for help.

CF_eConstruct ALERT!

Message: Value invalid for attribute, filterType.

Possible Values are:
  • Like
  • Exact
Consult your documentation for help.
SELECT * FROM Categories WHERE Parent = #categoryID# ORDER BY SORTID SELECT * FROM Categories WHERE CategoryID = #categoryID# ORDER BY SORTID SELECT * FROM Categories b WHERE Parent = #categoryID# ORDER BY SORTID SELECT * FROM Categories WHERE CategoryID = #CategoryID# ORDER BY SORTID SELECT * FROM Categories WHERE Parent = #getToken(parentCategoryID, 1, "|")# ORDER BY SORTID SELECT * FROM Categories WHERE CategoryID = #getToken(parentCategoryID, 1, "|")# ORDER BY SORTID SELECT * FROM Categories b WHERE Parent = #categoryID# ORDER BY SORTID SELECT * FROM Categories WHERE CategoryID = #CategoryID# ORDER BY SORTID

Message: #alertMsg#
 
SET concat_null_yields_null OFF SELECT a.productid, a.sortid, a.productpartno, a.vendorpartno, a.vendorid, a.productname, a.descriptionshort, a.descriptionLong, a.keywords, a.qtyinstock, a.taxable, a.weight, a.length, a.width, a.height, a.handlingfee, a.imagesmall, a.imagelarge, a.new, a.newenddate, c.categoryid, d.name, b.DiscountType, b.DiscountAmount, b.DiscountEndDate, b.DiscountStartDate, (select count(*) from OptionName where OptionName.ProductID = a.ProductID) AS optionCount, (select count(productid) from upSells where upSells.ProductID = a.ProductID) AS upSellCount SELECT DISTINCT a.productid, a.sortid, a.productpartno, a.vendorpartno, a.vendorid, a.productname, a.descriptionshort, NULL as descriptionLong, a.keywords, a.qtyinstock, a.taxable, a.weight, a.length, a.width, a.height, a.handlingfee, a.imagesmall, a.imagelarge, a.new, a.newenddate, c.categoryid, d.name, 0 as categoryid, NULL AS name, b.DiscountType, b.DiscountAmount, b.DiscountEndDate, b.DiscountStartDate, (select count(*) from OptionName where OptionName.ProductID = a.ProductID) AS optionCount, (select count(productid) from upSells where upSells.ProductID = a.ProductID) AS upSellCount 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 1=1 AND a.productID = #productID# AND c.CategoryID = #categoryID# AND vendorID = #getToken(vendorIDtoDisplay, 1, "|")# AND (b.DiscountStartDate <= '#todayDate#' AND b.DiscountEndDate >= '#todayDate#') AND ###todayDate### Between b.DiscountStartDate AND b.DiscountEndDate AND '#todayDate#' <= newEndDate AND New = 1 AND ###todayDate### <= newEndDate AND New = 1 AND ' ' + #replace("#filterfields#", "|", " + ' ' + ", "All")# like '%#LISTELEMENT#%' AND ' ' & #replace("#filterfields#", "|", " & ' ' & ", "All")# like '%#LISTELEMENT#%' AND ( OR #field# = '#filterFor#' ) ORDER BY a.sortid, a.productname  

#title#
#subslong.description##mainlong.description#

"#tablebgColor#""#altRowBgColor#">
#htmleditformat(productname)#
#htmleditformat(productname)# 		#htmleditformat(productname)# New!


CF_eConstruct ALERT!

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

Consult your documentation for help.

SKU: #htmleditformat(ProductPartno)#
Mfg. Part No.: #htmleditformat(VendorPartno)#
Dimensions: #htmleditformat(length)# in. x #htmleditformat(width)# in. x #htmleditformat(height)# in.

#trim(DescriptionShort)#

#trim(DescriptionLong)#

"#tablebgColor#""#altRowBgColor#">
#htmleditformat(productname)#

#htmleditformat(productname)#


CF_eConstruct ALERT!

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

Consult your documentation for help.

SKU: #htmleditformat(ProductPartno)#
Mfg. Part No.: #htmleditformat(VendorPartno)#
Dimensions: #htmleditformat(length)# in. x #htmleditformat(width)# in. x #htmleditformat(height)# in.

#trim(DescriptionShort)#

#trim(DescriptionLong)#

"#tablebgColor#""#altRowBgColor#">
    Product Desc. Price SKU: Mfg. Part No. Dimensions  
#htmleditformat(productname)# #htmleditformat(productname)# #htmleditformat(ProductName)# New! #trim(DescriptionShort)#

#trim(DescriptionLong)#

CF_eConstruct ALERT!

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

Consult your documentation for help.

#htmleditformat(ProductPartno)# #htmleditformat(VendorPartno)# #htmleditformat(length)# in. x #htmleditformat(width)# in. x #htmleditformat(height)# in.


#itemslong.productname# #itemslong.productname#

CF_eConstruct ALERT!

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

Consult your documentation for help.

SKU: #htmleditformat(ProductPartno)#
Mfg. Part No.: #htmleditformat(VendorPartno)#

 
 
«Previous  |  Next»
Go to Page: [#y#][#y#]
  SELECT a.*, b.DiscountType, b.DiscountAmount, b.DiscountEndDate, b.DiscountStartDate, (select count(*) from OptionName where OptionName.ProductID = a.ProductID) AS optionCount, c.categoryid, d.name FROM ((Products a LEFT JOIN Discounts b ON a.ProductID = b.ProductID) LEFT JOIN ProductsCategories c ON a.ProductID = c.ProductID) LEFT JOIN Categories d ON c.categoryID = d.categoryID WHERE a.productID = #productIDtoDisplay#
#htmleditformat(productname)#

#htmleditformat(productname)#
#htmleditformat(ProductName)# New!
CF_eConstruct ALERT!

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

Consult your documentation for help.

SKU: #htmleditformat(ProductPartno)#
Mfg. Part No.: #htmleditformat(VendorPartno)#
Dimensions: #htmleditformat(length)# in. x #htmleditformat(width)# in. x #htmleditformat(height)# in.

#trim(DescriptionShort)#

#trim(DescriptionLong)#

Sorry, there were no records found.
«Previous  |  Next»
Go to Page: [#y#][#y#]