>
> Can anybody shed some light on the error I am getting below, it is
> pointing at the date area of the code ?
More likely it is pointing at the semicolon.
> Any ideas why MX 6.1 does
> not like this, and how can I get around this problem ?
Strict interpretation of the JDBC spec says one query per statement.
> <cfquery datasource="#Application.DSN#" name="insert_query">
> INSERT INTO
> itarticle
> (id, articledate, articletitle, articlesummary, articleauthor,
> security, imgsrc)
> VALUES (
> #id#, TO_DATE('#formatted_date#', 'MM/DD/YYYY'), '#articletitle#',
> '#articlesummary#', '#Session.Fname# #Session.Lname#', '#security#',
> <cfif
> isdefined("file.serverFile")>'#file.serverFile#'<cfelse>NULL</cfif>)
> </cfquery>
This is not the query from the error.
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
