yeah, it was that. I changed the code to <cfset start = CreateODBCDate(DateFormat(event_start_date, 'yyyy-mm-dd'))>
<cfif event_end_date IS NOT ''> <cfset end = CreateODBCDate(DateFormat(event_end_date, 'yyyy-mm-dd'))> <cfelse> <cfset end = CreateODBCDate(DateFormat(event_start_date, 'yyyy-mm-dd'))> </cfif> and now it works fine. ta ;-) Ian W ----- Original Message ----- From: "Kevin Faulkner" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 29, 2003 5:27 PM Subject: RE: [ cf-dev ] syntax error > seems like a null enddate? > > -----Original Message----- > From: Ian Westbrook [mailto:[EMAIL PROTECTED] > Sent: 29 September 2003 17:18 > To: cfug dev list > Subject: [ cf-dev ] syntax error > > > another good old syntax error. I've stared at this for half an hour, can't > see what's wrong. anyone else any ideas? > > <cfset fromdate=createdate(year(now()),month(now()),day(now()))> > > <!-- this for gardner --> > <cfquery datasource="artsoutheast" name="grabdiary"> > SELECT * > FROM story_info > WHERE name = 'gardner' > AND story_type = 'diary' > AND > (( event_start_date >= #fromdate#) > OR > ( event_end_date >= #fromdate#)) > </cfquery> > > <cfoutput query="grabdiary"> > > <cfset start = CreateODBCDate(DateFormat(event_start_date, 'yyyy-mm-dd'))> > > <cfif event_end_date IS NOT ''> > <cfset end = CreateODBCDate(DateFormat(event_end_date, 'yyyy-mm-dd'))> > <cfelse> > <cfset end = ''> > </cfif> > > > <cfquery datasource="#dsn#"> > INSERT INTO diary (directoryid, reviewid, startdate, enddate, artform, > ticketprice, title, familyfriendly, audiodescribed, signed, surtext, > description, publish, eventimage, dateadded, edpick) VALUES (1, 0, > #variables.start#, #variables.end#, 0, 'varies', '#story_title#', 'no', > 'no', 'no', 'no', '#story_copy#', 'no', '#story_image#', > #CreateODBCDate(Now())#, 'no') > </cfquery> > > </cfoutput> > > ______________________________________________________ > ODBC Error Code = 37000 (Syntax error or access violation) > > [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO > statement. > > > SQL = "INSERT INTO diary (directoryid, reviewid, startdate, enddate, > artform, ticketprice, title, familyfriendly, audiodescribed, signed, > surtext, description, publish, eventimage, dateadded, edpick) VALUES (1, 0, > {d '2003-10-04'}, , 0, 'varies', 'Nicholas Nickleby [PG]', 'no', 'no', 'no', > 'no', 'An all star cast including Christopher Plummer, Jamie Bell and Jim > Broadbent head up this adaptation of one of Dicken's best-loved novels. ', > 'no', '', {d '2003-09-29'}, 'no')" > > Data Source = "ARTSOUTHEASTDEV" > > > The error occurred while processing an element with a general identifier of > (CFQUERY), occupying document position (36:1) to (36:28) in the template > file D:\artsoutheast\test\changedb.cfm. > > I wish the error messages would be a bit more useful - like telling you > where in the query it had got to before the syntax error occurred... > > any help appreciated. > > Ian W > DISCLAIMER: This e-mail is confidential and may also be legally privileged. > If you are not the intended recipient, use of the information contained in > this e-mail (including disclosure, copying or distribution) is prohibited > and may be unlawful. Please inform the sender and delete the message > immediately from your system. This e-mail is attributed to the sender and > may not necessarily reflect the views of the Patsystems Group and no member > of the Patsystems Group accepts any liability for any action taken in > reliance on the contents of this e-mail (other than where it has a legal or > regulatory obligation to do so) or for the consequences of any computer > viruses which may have been transmitted by this e-mail. The Patsystems Group > comprises Patsystems plc and its subsidiary group of companies. > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
