System Error
|
Module : scripts/_INCappDBConn_.asp : openRSopen(dbSource,dbCursorLoc,dbCursorType,dbLockType,dbOptions,dbCache) Number : -2147217900 Page : /furniture.asp Desc : Incorrect syntax near the keyword 'ORDER'. SQL : SELECT a.idProduct,a.idParentProduct,a.SKU,a.Description,a.filter,dimensions,a.details, q.confvalue prodSize, q.GroupWith groupwith, a.DescriptionLong,a.ListPrice,a.wholesaleprice,a.P2, a.Price,a.ImageUrl,a.Stock, a.fileName,a.noShipCharge,a.handlingfee, minorder, iduom FROM CP_products a INNER JOIN CP_categories_products b on a.idProduct = b.idProduct LEFT JOIN CP_Qpicks q on a.idSize=q.idPick WHERE a.idType in(213,214,378) AND b.idCategory = ORDER BY a.description,q.sortorder |