|
|
On Feb 22, 12:16 pm, "guddu2008" <webforumsu...@xxxxxxxxxxxxxx> wrote:
> Actually I am upgrading my system from coldfusion 4.5 to coldfusion 8. As
> database it is same for both Oracle 8.
> The same insertion statement is working in cold fusion 4.5 but showing error
> while working with coldfusion 8. It is showing error missing right
> parantheses.
> Query is:
>
> <cfset #QueryModelInsert#="
> INSERT INTO #ORADSQ#MNET_MODEL_YR
> (MMY_MODEL_YR,MMY_START_DATE,MMY_END_DATE,
> MMY_PRERIG_PAPER,MMY_PRERIG_ELEC,MMY_COOP_PAPER,
> MMY_COOP_ELEC,MMY_TRAVIS_REBATE)
>
> VALUES('#ModelYr#',To_Date('#StartDate#','yyyy-mm-dd'),To_Date('#EndDate#','yyyy
> -mm-dd'),#PrerigPaper#,
> #PrerigElec#,#CoopPaper#,#CoopElec#,#TravisRebate#)">
>
> <cfquery name="QueryModelInsert" datasource="#ORADSN#"
> username="#client.ORAUSERNAME#" password="#client.ORAPASSWORD#">
> #PreserveSingleQuotes(QueryModelInsert)#
> </cfquery>
>
> According to me perhaps some date format is creatin problem.
I do not know why it works on 4.5 (it has been a while since I used
it), but your problem with 8 is due to the fact that your query has
the same name as your query string "QueryModelInsert" - change the
name of your query...
|
|