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

Migrating from CFv.4.5 to MX7

Subject: Migrating from CFv.4.5 to MX7
From: "chewdb" <webforumsuser@xxxxxxxxxxxxxx>
Date: Mon, 24 Mar 2008 16:00:03 +0000 (UTC)
Newsgroups: macromedia.coldfusion.database_access

I am experiencing the following error after migrating code from v.4.5 to MX7.

 ***This code:
 <cfif isDefined("URL.Add")>
        <cfinsert DATASOURCE="eval"
            TABLENAME="tblGeneralEval"
            
FORMFIELDS="SCHD_ID,date,class,instructor,rotrain_id,stuname,GQ1,GQ2,GQ3,GQ4,GQ5
,GQ6,GQ7,GQ8,GQ9">
        
        <!--- <cfif #form.instructor# EQ (#qryInstr.instructor#)>
        <!--- duplicate instructor not added to the table --->
        <CFELSE> --->
                <cfinsert datasource="Eval" 
                        tablename="tblInstr" 
                        formfields="date,instructor">
                
        <!--- </cfif> --->
        <cfoutput>
                <cflocation url="thankyou.cfm">
        </cfoutput>
 </CFIF>

 ***Produces this error:
 Error Executing Database Query.  
 Syntax error in INSERT INTO statement.  

 The error occurred in E:\Web\Training\Evaluation\student\eval_general.cfm: 
line 4
  
 2 :    <cfinsert DATASOURCE="eval"
 3 :        TABLENAME="tblGeneralEval"
 4 :        
FORMFIELDS="SCHD_ID,date,class,instructor,rotrain_id,stuname,GQ1,GQ2,GQ3,GQ4,GQ5
,GQ6,GQ7,GQ8,GQ9">
 5 :    
 6 :    <!--- <cfif #form.instructor# EQ (#qryInstr.instructor#)>

  

 
--------------------------------------------------------------------------------

 SQL   insert into tblGeneralEval 
(SCHD_ID,date,instructorstuname,GQ1,GQ4,GQ5,GQ6,GQ7,GQ8) values ( (param 1) , 
(param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 
8) , (param 9) ) 
 DATASOURCE   eval 
 VENDORERRORCODE   3092 
 SQLSTATE   &nbsp; 
  
 Resources:  
 [b]Text[/b][b]Text[/b]


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