Is it because you select directory.id
AS directoryid then try to refer to directory.id in the WHERE statement when
you should refer to directoryid ?
Try diary.directoryid = directoryid
HTH
:�)
Stephen Pope
Development Team
Advanced Certified
Macromedia ColdFusion MX Developer
Eduserv Internet
managed hosting & development
[EMAIL PROTECTED]
tel: +44(0)1225 474371
fax: +44 (0)1225 474374
http://www.eduserv.org.uk/internet
Eduserv Internet is a service of Eduserv
Technologies Ltd
-----Original Message-----
From: Ian Westbrook (FDM)
[mailto:[EMAIL PROTECTED]
Sent: 17 March 2004 10:02
To: CFUG List
Subject: [ cf-dev ] anyone spot
what's wrong with this?
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
