I reackon it might be the quoteless dates! In a message dated 29/07/2003 15:25:59 GMT Daylight Time, [EMAIL PROTECTED] writes:
> -----Original Message----- > From: Ian Westbrook [mailto:[EMAIL PROTECTED] > Sent: 29 July 2003 15:16 > To: cfug dev list > Subject: [ cf-dev ] syntax error... > > > Hi > been staring at this for half an hour now, and can't see what's wrong with > it. anyone else have an idea? > > this is the query: > > <cfquery datasource="#dsn#" name="getdiary"> > 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 > <cfif form.town IS NOT 'all'> > AND directory.town = #form.town# > </cfif> > <cfif form.artform IS NOT 'all'> > AND diary.artform = #form.artform# > </cfif> > AND > (( diary.startdate >= #session.searchdatestart#) > OR > ( diary.enddate >= #session.searchdatestart#)) > AND diary.publish = 'yes' > ORDER BY diary.startdate, diary.enddate, diary.title > </cfquery> > > this is the error message: > > ODBC Error Code = 37000 (Syntax error or access violation) > > > [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in > query expression 'diary.directoryid = directory.id AND directory.town = > towns.id AND directory.town = 116 AND diary.artform = 10 AND (( > diary.startdate >= Tuesday July 29, 2003) OR ( diary.enddate >= Tuesday July > 29, 2003))'. > > > 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 = 116 AND diary.artform = 10 AND (( > diary.startdate >= Tuesday July 29, 2003) OR ( diary.enddate >= Tuesday July > 29, 2003)) ORDER BY diary.startdate, diary.enddate, diary.title" > > it doesn't seem to be seeing the WHERE in front of 'diary.directoryid = > directory.id', but I'll be buggered if I can see why. maybe a fresh pair of > eyes can spot it? > > TIA > > Ian W >
