<!--- do insert now --->
<CFQUERY NAME="qnews" DATASOURCE="#dsn#" USERNAME="#un#" PASSWORD="#pw#">
INSERT INTO guide (title, content, update)
VALUES ('#title#', '#content#', #createodbcdate(now())#)
</CFQUERY>
and i get this
Error Executing Database Query.
Syntax error or access violation: You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version for the
right syntax to use near 'update) VALUES ('test', 'f fdsf', '2004-02-20')'
The error occurred in C:\CFusionMX\wwwroot\RMA_new\admin\news\process.cfm:
line 22
20 : <CFQUERY NAME="qnews" DATASOURCE="#dsn#" USERNAME="#un#"
PASSWORD="#pw#">
21 : INSERT INTO guide (title, content, update)
22 : VALUES ('#title#', '#content#', #createodbcdate(now())#)
23 : </CFQUERY>
24 :
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
