Multiple record insert using ColdFusion not working
I am not receiving any errors, so I'm not sure where to start troubleshooting. I'm taking the field values from a master table and outputting them on my page, and then the user will check the check boxes which get their values from the master table, and then it will write all of the selections to a NEW table. Following is my code:
<cfinclude template="WA_DataAssist/WA_AppBuilder_CF.cfm">
<!--- application info --->
<cfquery name="getAppInfo" datasource="MYDSN">
SELECT *
FROM dbo.tblApplications
WHERE applicantID = <cfqueryparam value="#Session.applicantID#" cfsqltype="cf_sql_numeric">
</cfquery>
<cfquery name="getCK" datasource="MYDSN">
SELECT *
FROM dbo.tblScholarshipChecklist
</cfquery>
<cfif true>
<cfset RepeatSelectionCounter_1 = 0 >
<cfset RepeatSelectionCounterBasedLooping_1 = false >
<cfset RepeatSelectionNestedLoopStart_1 = 1 >
<cfset RepeatSelectionCounter_1_Iterations = "1" >
<cfif Not RepeatSelectionCounterBasedLooping_1 AND RepeatSelectionCounter_1_Iterations EQ "-1">
<cfset RepeatSelectionCounter_1_Iterations = getCK.RecordCount>
</cfif>
<cfif "getCK" NEQ "None">
<cfif IsDefined("MaxRows_getCK")>
<cfif IsDefined("StartRow_getCK") AND IsDefined("EndRow_getCK")>
<cfset RepeatSelectionNestedLoopEnd_1 = RepeatSelectionNestedLoopStart_1 + EndRow_getCK - StartRow_getCK >
<cfelse>
<cfset RepeatSelectionNestedLoopEnd_1 = RepeatSelectionNestedLoopStart_1 + MaxRows_getCK - 1 >
</cfif>
<cfelse>
<cfset RepeatSelectionNestedLoopEnd_1 = RepeatSelectionNestedLoopStart_1 + getCK.RecordCount - 1 >
</cfif>
<cfelse>
<cfset RepeatSelectionNestedLoopEnd_1 = RepeatSelectionNestedLoopStart_1 + RepeatSelectionCounter_1_Iterations - 1 >
</cfif>
<cfset RepeatSelection_1_PresentIteration = 0>
<cfset RepeatSelection_1_NestArray = ArrayNew(1)>
</cfif>
<cfif (isDefined("Form.submit")) >
<cfset WA_loopedFields = WA_ListToArray("checklistID","|") />
<cfset WA_connection = "MYDSN" />
<cfset WA_table = "dbo.tblApplicantChecklist" />
<cfset WA_redirectURL = "" />
<cfset WA_keepQueryString = false />
<cfset WA_fieldNamesStr = "applicantID|checklistID" />
<cfset WA_columnTypesStr = "none,none,NULL|none,none,NULL" />
<cfset WA_insertIfNotBlank = "applicantID" />
<cfset WA_fieldNames = WA_ListToArray(WA_fieldNamesStr,"|") />
<cfset WA_columns = WA_ListToArray(WA_columnTypesStr,"|") />
<cfset WA_multipleInsertCounter = 0 />
<cfloop condition="(WA_AB_checkMultiInsertLoopedFieldsExist(WA_loopedFields, WA_multipleInsertCounter))">
<cfif (WA_insertIfNotBlank EQ "" OR WA_AB_checkLoopedFieldsNotBlank(WA_ListToArray(WA_insertIfNotBlank,"|"), WA_multipleInsertCounter))>
<cfset WA_fieldValuesStr = "" & ToString(Session.applicantID) & "" & "|" & "" & ToString(WA_AB_getLoopedFieldValue("checklistID", WA_multipleInsertCounter)) & "" />
<cfset WA_fieldValues = WA_ListToArray(WA_fieldValuesStr,"|") />
<cfset insertParamsObj = WA_AB_generateInsertParams(WA_fieldNames, WA_columns, WA_fieldValues, -1) />
<cfset insertParamsObj2 = insertParamsObj[2] />
<cfquery datasource="#WA_connection#">
INSERT INTO #WA_table# (#insertParamsObj[1]#) VALUES (#PreserveSingleQuotes(insertParamsObj2)#)
</cfquery>
</cfif>
<cfset WA_multipleInsertCounter = WA_multipleInsertCounter+1 />
</cfloop>
<cfif (WA_redirectURL NEQ "")>
<cfif WA_keepQueryString AND CGI.QUERY_STRING NEQ "" >
<cfif Find("?", WA_redirectURL) GT 0 >
<cfset WA_redirectURL = WA_redirectURL & "&" & CGI.QUERY_STRING />
<cfelse>
<cfset WA_redirectURL = WA_redirectURL & "?" & CGI.QUERY_STRING />
</cfif>
</cfif>
<cflocation url="#WA_redirectURL#" addtoken="no">
</cfif>
</cfif>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
<!--
.style1 {font-size: 8px}
.style2 {
color: #990000;
font-weight: bold;
}
-->
</style>
</head>
<body>
<p>Check category/s of scholarship(s) you wish to be considered for. All applicants will be considered for a CSF General Scholarship. Scholarships may change depending on the receipt of funds from donors.</p>
<p align="center" class="style2">Place an X in each field you wish to be considered for.<br />
<br />
Applicant ID: <cfoutput>#Session.applicantID#</cfoutput></p>
<form id="form4" name="form4" method="POST">
<table width="95%" border="1" align="center" cellpadding="5" cellspacing="0" bordercolor="#CCCCCC">
<tr>
<td width="16%"><div align="center">Check Box</div></td>
<td width="17%"><div align="left">Category</div></td>
<td width="24%"><div align="left">Criteria and/or Area of Study</div></td>
<td width="43%"><div align="left">Name of Scholarship</div></td>
</tr>
<cfoutput query="getCK"><cfif RepeatSelection_1_PresentIteration EQ 0>
<cfset RepeatSelection_1_NestArray = ArrayNew(1)>
<cfsavecontent variable="RepeatSelection_1_temp">
<tr></cfsavecontent>
<cfset RepeatSelection_1_NestArray[1] = RepeatSelection_1_temp>
</cfif>
<cfsavecontent variable="RepeatSelection_1_temp">
<td valign="top"><div align="center">
<input type="checkbox" name="checklistID" id="checklistID" />
<span class="style1">#getCK.checklistID#</span></div></td>
<td valign="top"><div align="left"><br />#getCK.category#</div></td>
<td valign="top"><div align="left">#getCK.criteria#</div></td>
<td valign="top"><div align="left">#getCK.scholarshipName#
<input name="applicantID" type="hidden" id="applicantID" value="#Session.applicantID#" />
</div></td>
</cfsavecontent>
<cfset RepeatSelection_1_NestArray[(2+RepeatSelection_1_PresentIteration)] = RepeatSelection_1_temp>
<cfset RepeatSelection_1_PresentIteration = RepeatSelection_1_PresentIteration+1>
<cfset RepeatSelectionCounter_1 = RepeatSelectionCounter_1+1>
<cfif RepeatSelectionCounter_1 EQ RepeatSelectionNestedLoopEnd_1 AND RepeatSelection_1_PresentIteration LTE RepeatSelectionCounter_1_Iterations-1>
<cfloop from="#RepeatSelection_1_PresentIteration#" to="#RepeatSelectionCounter_1_Iterations-1#" index="RepeatSelectionCounter_1_Idx">
<cfsavecontent variable="RepeatSelection_1_temp">No records match your request.</cfsavecontent>
<cfset RepeatSelection_1_NestArray[(2+RepeatSelection_1_PresentIteration)] = RepeatSelection_1_temp>
<cfset RepeatSelection_1_PresentIteration = RepeatSelection_1_PresentIteration+1>
<cfset RepeatSelectionCounter_1 = RepeatSelectionCounter_1+1>
</cfloop>
</cfif>
<cfif RepeatSelection_1_PresentIteration EQ RepeatSelectionCounter_1_Iterations>
<cfsavecontent variable="RepeatSelection_1_temp"></cfsavecontent>
<cfset RepeatSelection_1_NestArray[(2+RepeatSelection_1_PresentIteration)] = RepeatSelection_1_temp>
<cfset RepeatSelection_1_PresentIteration = 0>
#ArrayToList(RepeatSelection_1_NestArray, "")#
</cfif></cfoutput>
</table>
<div align="center">
<input type="submit" name="submit" id="submit" value="Submit" />
</div>
</form>
</body>
</html>