?

Zoekresultaten voor "1223531 1223206"

 
Login voor meer informatie

[CMSAbstractTransformation.DataBind]: [DataConnection.HandleError]: Query: SELECT Tree.NodeID, Tree.NodeParentID, Tree.NodeAliasPath, Tree.DocumentName, Tree.ClassName, CMS_Attachment.AttachmentGUID, COM_SKU.SKUEnabled, COM_SKU.SKUNumber, COM_SKU.SKUName, COM_SKU.SKUPrice, COM_SKU.SKUSupplierID, COM_SKU.SKUAvailableItems, CASE WHEN COM_Supplier.ThirdPartyDelivery IS NULL THEN 0 ELSE COM_Supplier.ThirdPartyDelivery END AS ThirdPartyDelivery, COM_Supplier.IconExtraInformation, CASE WHEN AUV_Product.AOB IS NULL THEN 0 ELSE AUV_Product.AOB END AS AOB, CASE WHEN AUV_Product.QuoteOnly IS NULL THEN 0 ELSE AUV_Product.QuoteOnly END AS QuoteOnly, AUV_Product.AlertText, AUV_Product.SupplierAlertText, AUV_ProductPrices.Price, AUV_ProductPrices.SKUQuantity, AUV_ProductPrices.CustomerNumber, AUV_ProductActions.ActionText, AUV_CoreProducts.Status AS CoreProductStatus, CASE WHEN AUV_SupplierWhitelist.SupplierID IS NULL THEN 0 ELSE 1 END AS StockCheck, CASE WHEN AUV_MSDContracts.ItemID IS NULL THEN 0 ELSE 1 END AS HasMSDContract FROM View_CMS_Tree_Joined Tree LEFT JOIN CMS_Attachment ON CMS_Attachment.AttachmentDocumentID = Tree.DocumentID AND AttachmentMimeType = 'image/jpeg' LEFT JOIN COM_SKU ON COM_SKU.SKUID = Tree.NodeSKUID LEFT JOIN COM_Supplier ON COM_Supplier.SupplierID = COM_SKU.SKUSupplierID LEFT JOIN AUV_Product ON AUV_Product.ProductID = Tree.DocumentForeignKeyValue AND Tree.ClassName = 'AUV.Product' LEFT JOIN AUV_ProductActions ON AUV_ProductActions.ProductActionsID = Tree.DocumentForeignKeyValue AND Tree.ClassName = 'AUV.ProductActions' LEFT JOIN AUV_CoreProducts ON AUV_CoreProducts.ProductNumber = COM_SKU.SKUNumber AND (AUV_CoreProducts.CustomerPriceGroup IS NULL OR AUV_CoreProducts.CustomerPriceGroup = @customerPricegroup) LEFT JOIN AUV_ProductPrices ON AUV_ProductPrices.SKUNumber = COM_SKU.SKUNumber AND ((AUV_ProductPrices.CustomerNumber = @customerNumber) OR (AUV_ProductPrices.CustomerNumber IS NULL)) AND GETDATE() BETWEEN AUV_ProductPrices.DateFrom AND AUV_ProductPrices.DateTo LEFT JOIN AUV_SupplierWhitelist ON AUV_SupplierWhitelist.SupplierID = COM_SKU.SKUSupplierID LEFT JOIN AUV_MSDContracts ON AUV_MSDContracts.SKUNumber = COM_SKU.SKUNumber AND AUV_MSDContracts.CustomerNumber = @customerNumber WHERE Tree.NodeID = @nodeId AND ( [DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= GETDATE()) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= GETDATE()) ) ORDER BY Tree.NodeOrder Caused exception: Must declare the scalar variable "@customerPricegroup".
Login voor meer informatie

[CMSAbstractTransformation.DataBind]: [DataConnection.HandleError]: Query: SELECT Tree.NodeID, Tree.NodeParentID, Tree.NodeAliasPath, Tree.DocumentName, Tree.ClassName, CMS_Attachment.AttachmentGUID, COM_SKU.SKUEnabled, COM_SKU.SKUNumber, COM_SKU.SKUName, COM_SKU.SKUPrice, COM_SKU.SKUSupplierID, COM_SKU.SKUAvailableItems, CASE WHEN COM_Supplier.ThirdPartyDelivery IS NULL THEN 0 ELSE COM_Supplier.ThirdPartyDelivery END AS ThirdPartyDelivery, COM_Supplier.IconExtraInformation, CASE WHEN AUV_Product.AOB IS NULL THEN 0 ELSE AUV_Product.AOB END AS AOB, CASE WHEN AUV_Product.QuoteOnly IS NULL THEN 0 ELSE AUV_Product.QuoteOnly END AS QuoteOnly, AUV_Product.AlertText, AUV_Product.SupplierAlertText, AUV_ProductPrices.Price, AUV_ProductPrices.SKUQuantity, AUV_ProductPrices.CustomerNumber, AUV_ProductActions.ActionText, AUV_CoreProducts.Status AS CoreProductStatus, CASE WHEN AUV_SupplierWhitelist.SupplierID IS NULL THEN 0 ELSE 1 END AS StockCheck, CASE WHEN AUV_MSDContracts.ItemID IS NULL THEN 0 ELSE 1 END AS HasMSDContract FROM View_CMS_Tree_Joined Tree LEFT JOIN CMS_Attachment ON CMS_Attachment.AttachmentDocumentID = Tree.DocumentID AND AttachmentMimeType = 'image/jpeg' LEFT JOIN COM_SKU ON COM_SKU.SKUID = Tree.NodeSKUID LEFT JOIN COM_Supplier ON COM_Supplier.SupplierID = COM_SKU.SKUSupplierID LEFT JOIN AUV_Product ON AUV_Product.ProductID = Tree.DocumentForeignKeyValue AND Tree.ClassName = 'AUV.Product' LEFT JOIN AUV_ProductActions ON AUV_ProductActions.ProductActionsID = Tree.DocumentForeignKeyValue AND Tree.ClassName = 'AUV.ProductActions' LEFT JOIN AUV_CoreProducts ON AUV_CoreProducts.ProductNumber = COM_SKU.SKUNumber AND (AUV_CoreProducts.CustomerPriceGroup IS NULL OR AUV_CoreProducts.CustomerPriceGroup = @customerPricegroup) LEFT JOIN AUV_ProductPrices ON AUV_ProductPrices.SKUNumber = COM_SKU.SKUNumber AND ((AUV_ProductPrices.CustomerNumber = @customerNumber) OR (AUV_ProductPrices.CustomerNumber IS NULL)) AND GETDATE() BETWEEN AUV_ProductPrices.DateFrom AND AUV_ProductPrices.DateTo LEFT JOIN AUV_SupplierWhitelist ON AUV_SupplierWhitelist.SupplierID = COM_SKU.SKUSupplierID LEFT JOIN AUV_MSDContracts ON AUV_MSDContracts.SKUNumber = COM_SKU.SKUNumber AND AUV_MSDContracts.CustomerNumber = @customerNumber WHERE Tree.NodeID = @nodeId AND ( [DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= GETDATE()) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= GETDATE()) ) ORDER BY Tree.NodeOrder Caused exception: Must declare the scalar variable "@customerPricegroup".

Product is toegevoegd aan uw winkelwagen