Use CreateODBCDate() function in your query. You might need to create a real date from the text you get for your date using CreateDate()
STephen
Ian Westbrook (FDM) wrote:
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
-- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*To unsubscribe, e-mail: [EMAIL PROTECTED]
