Stackoverflow Q54794658

<!--- 1. Change function to enable output:  output="TRUE" --->
<!--- 2. Place this code right BEFORE the cfquery that fails --->
<cfsavecontent variable="local.debugQuery"><cfoutput>
     &lt;cfquery name="saveRec" datasource="testDB">
            &lt;cfloop array="#arrStatus#" index="i">
                INSERT INTO formDetails (
                    formid,
                    refid,
                    status,
                    comment,
                    userid,
                    lastupdate
                )
                SELECT
                    &lt;cfqueryparam cfsqltype="cf_sql_numeric" value="#trim(arguments.formID)#">,
                    #i#,
                    &lt;cfqueryparam cfsqltype="cf_sql_bit" value="#trim(arguments["status"&i])#">,
                    &lt;cfqueryparam cfsqltype="cf_sql_varchar" maxlength="8000" value="#trim(arguments["comment"&i])#" null="#!len(trim(arguments["comment"&i]))#">,
                    &lt;cfqueryparam cfsqltype="cf_sql_varchar" maxlength="6" value="#trim(session.userid)#" null="#!len(trim(session.userid))#">,
                    #now()#
                WHERE NOT EXISTS (
                    SELECT refid
                    FROM formDetails
                    WHERE formid = &lt;cfqueryparam cfsqltype="cf_sql_numeric" value="#trim(arguments.formID)#">
                        AND refid = #i#
                )
            &lt;/cfloop>
</cfoutput></cfsavecontent>

<cfoutput>local.debugQuery = #local.debugQuery#</cfoutput>