Back to basics lads. The datatime needs to be in single quotes for a start. Secondly, is it an access db because if so dates need to be in #'s so you will need to triple escape them i.e. ###data### and thirdly, the only guaranteed way to pass dates and not confuse the locale settings of the db is to use dateformat(yourdate, 'dd-mmm-yyyy')
Ellis C Wood BSc Ellwood Web Solutions T: 01623 459973 E: [EMAIL PROTECTED] W: http://www.ellwoodwebsolutions.co.uk -----Original Message----- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 17 March 2004 10:04 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] anyone spot what's wrong with this? You need to pass ODBC Dates rather than 'Friday October 1, 2004' 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] -- 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]
