Error Diagnostic InformationODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'StoryID = 210 AND Decade = 12 AND Type = AND Published = 1'. SQL = "SELECT StoryID, Published, Decade, Type, Date, Title, Subtitle, Body, Graphic, Author, Label, Width, Height FROM Stories WHERE StoryID = 210 AND Decade = 12 AND Type = AND Published = 1 ORDER BY StoryID" Data Source = "COLORTEST" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (6:1) to (8:13) in the template file S:\COLOREDREFLECTIONSROOT\DECADES\DECADE.CFM. Date/Time: 08/23/07 16:21:33 |