[ cf-dev ] anyone spot what's wrong with this?

[Ian Westbrook \(FDM\)]

HI can anyone spot what's wrong with this? this is the error message...   Something just went wrong on ArtSouthEast. Below is the error information. Sort it aaaaaaht! ODBC Error Code = 37000 (Syntax error or access violation)<P> [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query _expression_ 'diary.directoryid = directory.id AND directory.town = towns.id AND directory.town = 148 AND diary.artform = 35 AND (( diary.startdate >= Friday October 1, 2004) OR ( diary.enddate >= Friday October 1, 2004)) AND diary.publish = 'ye'.<P><P>SQL = "SELECT diary.id AS diaryid, diary.directoryid, diary.artform AS diaryartform, diary.*, directory.id AS directoryid, directory.fullname, directory.town, towns.id AS townid, towns.town AS town FROM diary, directory, towns WHERE diary.directoryid = directory.id AND directory.town = towns.id AND directory.town = 148 AND diary.artform = 35 AND (( diary.startdate >= Friday October 1, 2004) OR ( diary.enddate >= Friday October 1, 2004)) AND diary.publish = 'yes' ORDER BY diary.startdate, diary.enddate, diary.title"<P>Data Source = "ARTSOUTHEAST"<P><p>The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (360:2) to (360:45) in the template file D:\ARTSOUTHEAST\HTDOCS\INCLUDES\DIARY.CFM.</p> D:\ARTSOUTHEAST\HTDOCS\DIARY.CFM     TIA   Ian W