Updated Code. I wanted to make sure that the correct data was being captured, and it is.
<cfoutput>#Session.applicantID#</cfoutput> :: <cfoutput>#IIf(isDefined("Form.checklistID"),"Form.checklistID",DE(""))#</cfoutput>
<cfabort>
It's just not writing anything to the database table. Nothing at all and no errors.
********************************************************************
********************************************************************
********************************************************************
<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")) >
<cfoutput>#Session.applicantID#</cfoutput> :: <cfoutput>#IIf(isDefined("Form.checklistID"),"Form.checklistID",DE(""))#</cfoutput>
<cfabort>
<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 name="checklistID" type="checkbox" id="checklistID" value="#getCK.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>