System Error

Number : -2147217913

Page : /shop/products-list.asp

Desc : Data type mismatch in criteria expression.

SQL : SELECT Manufacturers.idManufacturer,Manufacturers.ManufacturerName, Count(products.description) AS TotItems FROM Categories_Products INNER JOIN (Products INNER JOIN Manufacturers ON CInt(Products.itemManufacturer) = Manufacturers.idManufacturer) ON Categories_Products.idProduct = Products.idProduct WHERE Categories_Products.idCategory = 579 AND products.active = -1 GROUP BY Manufacturers.idManufacturer, Manufacturers.ManufacturerName ORDER BY Manufacturers.ManufacturerName