Date and Time are reserved words in most databases. christopher olive, cio cresco technologies, inc http://www.crescotech.com -----Original Message----- From: Dusty Tinashe Shoko [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 9:36 AM To: CF-Talk Subject: Re: SQL Thanks guys here is the error msg ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (59:9) to (59:40). and here is the code snippet <CFSET Date=#Dateformat(CreateODBCDate(Form.Date), "mm/dd/yy")#> <CFSET EndDate=#Dateformat(CreateODBCDate(Form.EndDate), "mm/dd/yy")#> <CFSET Time=#Timeformat(CreateODBCTime(Form.Time), "HH:mm:ss")#> <CFIF isdefined("Form.EndTime")> <CFSET EndTime=#Timeformat(CreateODBCTime(Form.EndTime), "HH:mm:ss")#> <CFELSE> <CFSET EndTime=#Timeformat(CreateODBCTime(0), "HH:mm:ss")#> </CFIF> <CFQUERY datasource="intranet"> INSERT INTO Events (Date, EndDate, Time, EndTime, Venue, Desc, Attendees, Category) VALUES (#Date#, #EndDate#, #Time#, #EndTime#, #Form.Venue#, #Form.Desc#, #Form.Attendees#, #Form.Category#) </CFQUERY> ----- Original Message ----- From: Andrew Scott <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Friday, August 31, 2001 3:04 PM Subject: RE: SQL > Yes it is, but if the field is an int then you will have to remove the ' > . > > It may pay to post the error message so that we can identify the exact > problem:-) > > > Regards, > Andrew Scott > > > -----Original Message----- > From: Dusty Tinashe Shoko [mailto:[EMAIL PROTECTED]] > Sent: Friday, 31 August 2001 11:06 PM > To: CF-Talk > Subject: SQL > > People help > <CFQUER datasource="mydbsource"> > INSERT INTO TABLENAME (Field1, Field2, Field3,....) > VALUES ('Value1', 'Value2', 'Value3',...) > </CFQUERY> > > Is that the proper syntax? > Sp Field1 is a date got from the form how would I make sure it is > inserted in a format I like? Can I do a dateformat within the query? > I am getting a syntax error! > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
