|
An error occurred executing the following query; SELECT DISTINCTROW tblCactuShopProducts.P_Name1, tblCactuShopVersions.V_Price, tblCactuShopVersions.V_Weight, tblCactuShopVersions.V_RRP, tblCactuShopVersions.V_CodeNumber, tblCactuShopVersions.V_Name1, tblCactuShopVersions.V_ID, tblCactuShopVersions.V_Desc1, tblCactuShopTaxRates.T_Taxrate, tblCactuShopVersions.V_Live, tblCactuShopVersions.V_Quantity, tblCactuShopVersions.V_DownloadType, tblCactuShopVersions.V_DowloadFileName, tblCactuShopVersions.V_QuantityWarnLevel, tblCactushopPriceClass.PC_Price, tblCactushopPriceClass.PC_SalePrice, tblCactushopPriceClass.PC_SaleActive FROM ((tblCactuShopVersions INNER JOIN ((tblCactuShopProducts INNER JOIN tblCactuShopProductProdTypeLink ON tblCactuShopProducts.P_ID = tblCactuShopProductProdTypeLink.PPT_ProductID) INNER JOIN tblCactuShopProdtype ON tblCactuShopProductProdTypeLink.PPT_ProdTypeID = tblCactuShopProdtype.PT_ID) ON tblCactuShopVersions.V_Product = tblCactuShopProducts.P_ID) LEFT JOIN tblCactushopPriceClass ON tblCactuShopVersions.V_PriceClass = tblCactushopPriceClass.PC_ID) INNER JOIN tblCactuShopTaxRates ON tblCactuShopVersions.V_Tax = tblCactuShopTaxRates.T_ID WHERE tblCactuShopVersions.V_Live ='y' AND P_ID = 1040 AND P_Live = 'y' AND PT_Live = 'y' AND V_Name1 <> '' ORDER BY V_Name1 Error Description :
Incorrect syntax near '.'. Page of error :
/prodtype.asp Query String :
PT_ID=894&strPageHistory=cat |
