No FROM clause as far as I can see? ----- Original Message ----- From: Ian Westbrook (FDM) To: CFUG List Sent: Thursday, January 08, 2004 1:50 PM Subject: [ cf-dev ] fresh pair of eyes...
can anyone see what's wrong with this? I've been staring at it for half an hour now... I'm getting an error [Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect. CF4.5, Access db <cfquery datasource="#dsn#" name="events"> SELECT directory.id, directory.postcode, directory.fullname, directory.boxofficetelephone, directory.town, diary.directoryid AS directoryid, diary.startdate, diary.enddate, diary.publish, diary.description, diary.title, diary.artform, diary.ticketprice, diary.concessions, artforms.id, artforms.artform AS artform, towns.id, towns.town AS town WHERE (directory.postcode LIKE 'TN%' OR directory.postcode LIKE 'CT%' OR directory.postcode LIKE 'BR%' OR directory.postcode LIKE 'BN%') AND directory.id = diary.directoryid AND directory.town = towns.id AND diary.artform = artforms.id AND (( diary.startdate >= #nowdate#) OR ( diary.enddate >= #nowdate#)) AND diary.publish = 'yes' ORDER BY diary.startdate, diary.title </cfquery> TIA Ian W
