Error Diagnostic Information

ODBC Error Code = S0022 (Column not found)

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Specials'.

SQL = "SELECT S4LProducts.*,S4LCategories.* FROM S4LProducts INNER JOIN S4LCategories on S4LProducts.CategoryID = S4LCategories.CategoryID WHERE S4LProducts.CategoryID = Specials AND S4LProducts.ItemID = 269 ORDER BY S4LProducts.CategoryID,S4LProducts.ItemName"

Data Source = "AMP"

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (98:1) to (98:57) in the template file D:\GBOULTON\STROLLERS4LESS\WEB\PRODDETAIL.CFM.

Date/Time: 12/06/02 09:28:11
Browser: ia_archiver
Remote Address: 209.237.238.163
Query String: ItemID=269&CategoryID=Specials