When I run following cfml file in CF V4.5, I get ORA-00911: invalid character error.
<cflock name="InsertNewRecord" type = "EXCLUSIVE" timeout="60">
<cftransaction>
<CFIF #FORM.MELD# LE 10>
<CFSET NEXTDT = DateAdd("d", 365, "#FORM.MDATE#")>
<CFELSEIF #FORM.MELD# GE 11 and #FORM.MELD# LT 19>
<CFSET NEXTDT = DateAdd("d", 90, "#FORM.MDATE#")>
<CFELSEIF #FORM.MELD# GE 19 and #FORM.MELD# LT 25>
<CFSET NEXTDT = DateAdd("d", 30, "#FORM.MDATE#")>
<CFELSEIF #FORM.MELD# GE 25>
<CFSET NEXTDT = DateAdd("d", 7, "#FORM.MDATE#")>
</CFIF>
<cfquery NAME = "AddRecord" datasource="scm">
INSERT INTO T_MELD
(XID, MDATE, MELD, NEXTDT, MP)
VALUES
('#FORM.XID#',
TO_DATE('#FORM.MDATE#', 'mm/dd/yyyy'),
#FORM.MELD#,
#NEXTDT#,
'#FORM.MP#'
)
</cfquery>
</cftransaction>
</cflock>
<html>
<head>
<title>New MELD Info Added! </title>
</head>
<body>
<H2 class="style1">New MELD Record Added!</H2>
</body>
</html>
Will you help me?
<cflock name="InsertNewRecord" type = "EXCLUSIVE" timeout="60">
<cftransaction>
<CFIF #FORM.MELD# LE 10>
<CFSET NEXTDT = DateAdd("d", 365, "#FORM.MDATE#")>
<CFELSEIF #FORM.MELD# GE 11 and #FORM.MELD# LT 19>
<CFSET NEXTDT = DateAdd("d", 90, "#FORM.MDATE#")>
<CFELSEIF #FORM.MELD# GE 19 and #FORM.MELD# LT 25>
<CFSET NEXTDT = DateAdd("d", 30, "#FORM.MDATE#")>
<CFELSEIF #FORM.MELD# GE 25>
<CFSET NEXTDT = DateAdd("d", 7, "#FORM.MDATE#")>
</CFIF>
<cfquery NAME = "AddRecord" datasource="scm">
INSERT INTO T_MELD
(XID, MDATE, MELD, NEXTDT, MP)
VALUES
('#FORM.XID#',
TO_DATE('#FORM.MDATE#', 'mm/dd/yyyy'),
#FORM.MELD#,
#NEXTDT#,
'#FORM.MP#'
)
</cfquery>
</cftransaction>
</cflock>
<html>
<head>
<title>New MELD Info Added! </title>
</head>
<body>
<H2 class="style1">New MELD Record Added!</H2>
</body>
</html>
Will you help me?