I have just migrated from CF 4.5 to MX 6.1, and I am receiving the
following error since doing so even though it worked when using
Coldfusion 4.5, could it because of Coldfusion MX ??
Can anybody/experts on the list see why this error may be occuring, and
suggested solutions ?
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\articleaction.cfm: line 69
67 : and articleauthor = '#Session.Fname#
#Session.Lname#'
68 : and security = '#security#'
69 : and articledate = TO_DATE('#formatted_date#',
'MM/DD/YYYY');
70 : END;
71 : </cfquery>
<cftransaction>
<cfquery name="LOOKUP" datasource="intranetv8">
SELECT Max(id) NewID
FROM itarticle
</cfquery>
<cfif lookup.newid is "">
<cfset id = 1>
<cfelse>
<cfset id = lookup.newid + 1>
</cfif>
<!--- Insert contact into the contacts tabel in the tes8 Database --->
<cfset articledate = form.event_month & "/" & form.event_day & "/" &
form.event_year>
<cfset articledate = #CreateODBCDate(articledate)#>
<cfset formatted_date = dateformat(articledate, "MM/DD/YYYY")>
<cfset content = REReplacenocase(content, "</*font[^<>]*>", "", "ALL")>
<cfset content = REReplacenocase(content, "</*span[^<>]*>", "", "ALL")>
<cfif form.uploadfile neq "">
<cffile action="" filefield="Form.UploadFile"
destination="F:\Websites\Intranet\itintranet\itnews\images\"
nameconflict="OVERWRITE">
</cfif>
<!--- Make sure that file is of correct type --->
<!--- Insert the story record --->
<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>
<!--- Insert the long text into the story record --->
<cfquery datasource="#Application.DSN#" name="insert_query">
DECLARE new_text LONG;
BEGIN
new_text := '#content#';
UPDATE itarticle
SET articlebody = new_text
WHERE id = #id#
and articletitle = '#articletitle#'
and articlesummary = '#articlesummary#'
and articleauthor = '#Session.Fname# #Session.Lname#'
and security = '#security#'
and articledate = TO_DATE('#formatted_date#', 'MM/DD/YYYY');
END;
</cfquery>
</cftransaction>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
