System Error
|
Module : scripts/_INCappDBConn_.asp : openRSexecute(mySQL) Number : -2147217900 Page : /scripts/prodList.asp Desc : [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'OR'. SQL : SELECT Count(*) AS prodCount FROM products AS a INNER JOIN productTypes_Products b ON a.idProduct = b.idProduct INNER JOIN productTypes c ON b.idProdType = c.idProdType WHERE a.active = -1 AND c.idParentProdType = 15 AND ((a.details LIKE OR (a.description1 LIKE OR (a.description2 LIKE OR (a.descriptionLong LIKE OR (a.SKU LIKE ) |