System Error
|
Number : -2147217900 Page : /prodList.asp Desc : [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'a.idProduct = b.idProduct AND b.idCategory = 40 AND a.lType = AND a.active = -1'. SQL : SELECT a.idProduct,a.SKU,a.Description, a.DescriptionLong,a.ListPrice, a.Price,a.SmallImageUrl,a.Stock,a.type, a.fileName,a.noShipCharge,a.ltype FROM products a, categories_products b WHERE a.idProduct = b.idProduct AND b.idCategory = 40 AND a.lType = AND a.active = -1 ORDER BY a.description |