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 Ian Westbrook, FutureDream Media Limited, (W): www.futuredream.net (E): [EMAIL PROTECTED] (T): +44 (0) 1303 258 985 (M): 07939 510 812 This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding any comments, opinions, information or conclusions expressed in this message are those of the originator, not of FutureDream Media Ltd, unless otherwise explicitly and independently indicated by an authorised representative of FutureDream Media Ltd.
