sorry, see original query that I posted as a PS. this is driving me nuts! all the variables are being pased OK from the form, and this was working fine until a day or two ago. I musta changed soemthing by accident...
Ian W ----- Original Message ----- From: "Ellwood" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 17, 2004 10:13 AM Subject: RE: [ cf-dev ] anyone spot what's wrong with this? > 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] > > -- 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]
