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]
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
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
