 			<cfdump var=#myQueryResult#>
 		</p>
 		<p>
+			Use your back button or <a href="pre_bulkloader.cfm">continue</a>
+		</p>
+	</cfif>
+	<!------------------------------------------------------->
+	<cfif action is "buildCollectionObjectID">
+		<cfquery name="uppc" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#" result="myQueryResult">
+			UPDATE pre_bulkloader SET collection_object_id=bulkloader_pkey.nextval WHERE collection_object_id is null
+		</cfquery>
+
+		<p>
+			Results:
+			<cfdump var=#myQueryResult#>
+		</p>
+		<p>
+			Use your back button or <a href="pre_bulkloader.cfm">continue</a>
+		</p>
+	</cfif>
+	<!------------------------------------------------------->
+	<cfif action is "execSQL">
+		<cfquery name="uppc" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#" result="myQueryResult">
+			UPDATE pre_bulkloader SET #preserveSingleQuotes(spf)# <cfif len(spw) gt 0>WHERE #preserveSingleQuotes(spw)#</cfif>
+		</cfquery>
+
+		<p>
+			Results:
+			<cfdump var=#myQueryResult#>
+		</p>
+		<p>
 			Use your back button or <a href="pre_bulkloader.cfm?action=nothing##tysql">continue</a>
 		</p>
 	</cfif>
 
 	<!------------------------------------------------------->
+	<cfif action is "setNullDefaultsAttribute">
+		<cfset numberOfAttributes=10>
+		<cfif len(attribute_determiner_n) gt 0>
+			<cfloop from="1" to="#numberOfAttributes#" index="i">
+				<cfquery name="uppc" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
+					update
+						pre_bulkloader
+					set
+						attribute_determiner_#i#='#escapeQuotes(attribute_determiner_n)#'
+					where
+						attribute_#i# is not null and
+						attribute_determiner_#i# is null
+				</cfquery>
+			</cfloop>
+		</cfif>
+		<cfif len(attribute_date_n) gt 0>
+			<cfloop from="1" to="#numberOfAttributes#" index="i">
+				<cfquery name="uppc" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
+					update
+						pre_bulkloader
+					set
+						attribute_date_#i#='#escapeQuotes(attribute_date_n)#'
+					where
+						attribute_#i# is not null and
+						attribute_date_#i# is null
+				</cfquery>
+			</cfloop>
+		</cfif>
+		<cflocation url="pre_bulkloader.cfm" addtoken="false">
+	</cfif>
+	<!------------------------------------------------------->
 	<cfif action is "setNullDefaultsParts">
+		<cfset numberOfParts=12>
 		<cfif len(PART_CONDITION_n) gt 0>
-			<cfloop from="1" to="10" index="i">
+			<cfloop from="1" to="#numberOfParts#" index="i">
 				<cfquery name="uppc" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
 					update
 						pre_bulkloader

				</form>
			</li>
			<li>
				<a name="tysql"></a>
				<form name="pdflt" method="post" action="pre_bulkloader.cfm">
					<input type="hidden" name="action" value="execSQL">

			</cfloop>
		</cfif>
		<cfif len(PART_DISPOSITION_n) gt 0>
			<cfloop from="1" to="#numberOfParts#" index="i">
				<cfquery name="uppc" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
					update
						pre_bulkloader
