UPDATE...... thats a reserved word in SQL....
As in UPDATE tblname SET col = 123 WHERE tblID = 567
You need to change that column name to something other than 'update'
even 'update_date' would be better!
Damn it!! should have spotted that right off... Anyone would think it
was Monday morning not Friday morning!!
Stephen
[EMAIL PROTECTED] wrote:
> i had already tried all those but 1 which is
> <!--- 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]
