> think twice about it, until i ran it & it choked. U'd think that would be
> properly formated
>
> so when i use
> <!--- do insert now --->
> <CFQUERY NAME="qnews" DATASOURCE="#dsn#" USERNAME="#un#" PASSWORD="#pw#">
> INSERT INTO guide (title, content, update)
> VALUES ('#title#', '#content#', #Now()#)
> </CFQUERY>
>
> i get
>
> 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 ('dddddd', 'dsfdfdfdsf f',
> '2004-0
>
Ermmm.... A bit further down in the error message you should be able to
see the complete SQL statement that was created/sent.
Can you post that please?
Also, what version of CF are you on? 4.5x?
Regards
Stephen
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]