macromedia.coldfusion.database_access
[Top] [All Lists]

Inserting by ame query in coldfusion 4.5 and coldfusion 8 creates proble

Subject: Inserting by ame query in coldfusion 4.5 and coldfusion 8 creates problem
From: "guddu2008" <webforumsuser@xxxxxxxxxxxxxx>
Date: Fri, 22 Feb 2008 12:16:57 +0000 (UTC)
Newsgroups: macromedia.coldfusion.database_access

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. 


<Prev in Thread] Current Thread [Next in Thread>