Avoid using generic table and column names (such as "text") if at all possible. If you MUST, enclose it in brackets [] so that the driver will know you mean a table/column name instead of a data type.
-Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com ----- Original Message ----- From: "Patric Stumpe" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, April 20, 2002 5:46 PM Subject: DB problem > Hi fellows, > > I'm stumbling about an SQL-error. > > I'm just trying to insert some stupid news-ticker-data to an acces-db, > but the following error appears: > -------------------------------- > ODBC Error Code = 37000 (Syntax error or access violation) > > > [Microsoft][ODBC Microsoft Access Driver] Syntaxfehler in der INSERT INTO-Anweisung. > > > SQL = "INSERT INTO news (text, startdatum, enddatum, aktiv) VALUES ('test-news', {ts '2002-04-20 00:00:00'}, {ts '2002-05-20 00:00:00'}, 1)" > > Data Source = "MAX_FORUM" > > > The error occurred while processing an element with a general > identifier of (CFQUERY), occupying document position (6:2) to (6:51) > in the template file D:\inetpub\site\_admin\action_news.cfm. > ------------------------------ > > My action looks like this: > -------------------------- > <cfset startdatum = CreateODBCDateTime(CreateDate(#form.startjahr#, #form.startmonat#, #form.starttag#))> > <cfset enddatum = CreateODBCDateTime(CreateDate(#form.endjahr#, #form.endmonat#, #form.endtag#))> > > <cfquery name="insertNews" datasource="max_forum"> > INSERT INTO news (text, startdatum, enddatum, aktiv) > VALUES ('#HTMLEditFormat(form.text)#', #startdatum#, #enddatum#, #form.aktiv#) > </cfquery> > ----------------------------- > > > The db-fields are defined as these: > > TABLE news > id (Auto) > text (MEMO) > startdatum (DateTime) > enddatum (DateTime) > aktiv (BIT) > > > Any ideas???? > > > -- > best regards > > Patric Stumpe mailto:[EMAIL PROTECTED] > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
