Can anybody shed some light on the error I am getting below, it is
pointing at the date area of the code ? Any ideas why MX 6.1 does not
like this, and how can I get around this problem ?
Code Snippet ---
<cfset storydate = #CreateODBCDate(storydate)#>
<cfset formatted_date = dateformat(storydate, "MM/DD/YYYY")>
<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>
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 23:
PLS-00103: Encountered the symbol "" when expecting one of the
following: begin function package pragma procedure subtype type use
cursor form current
The error occurred in
F:\Websites\Intranet\itintranet\publishing\updatearticleaction.cfm: line
48
46 : SET articlebody = new_text
47 : WHERE id = #id# and articlesummary = '#articlesummary#' and
articletitle = '#articletitle#' and articleauthor = '#Session.Fname#
#Session.Lname#' and imgsrc = <cfif
isdefined("file.serverFile")>'#file.serverFile#'<cfelse>NULL</cfif> and
security = '#security#' and articledate =
48 : TO_DATE('#formatted_date#', 'MM/DD/YYYY');
49 : END;
50 : </cfquery>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
