Migrating Code from v.4.5 to v.MX6

[DChew <chewdb@xxxxxxxxx>]

Hello,

Can anyone tell me why the following code would no longer work in MX
when it worked in v.4.5? I did define the data source through the
Administrator.

Thanks for your help.

<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>

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;