Course Listing

[Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@P1AND".: SELECT vwCatalog.idCatalog, vwCatalog.idOrganization, vwCatalog.idParentCatalog, vwCatalog.isRestricted, vwCatalog.isParentRestricted, vwCatalog.courseCount, vwCatalog.catalogCount, vwCatalog.name, vwCatalog.color, vwCatalog.description FROM vwCatalog LEFT JOIN tblCatalogAccess on tblCatalogAccess.idCatalog = vwCatalog.idCatalog WHERE  vwCatalog.idCatalog in (81) AND vwCatalog.idOrganization = ?AND vwCatalog.isRestricted = ? ORDER BY (CASE WHEN LOWER(vwCatalog.name) = 'new courses' THEN 1 ELSE 2 END) ASC
error getting catalog