Batch insert records to a database

gistfile1.cfm

<cfscript>
  totalrows = 5000; // this would come from a structCount or something similar
  rowsPerInsert = 210;
  //this creates a struct with alternating values of true/false for test purposes
  stRows = {};
  for(i=1; i<=totalRows; i++) {
    stRows[i] = i MOD 2 ? true : false;
  }
</cfscript>
<cfoutput>
<cfloop from="0" to="#totalRows - 1#" step="#rowsPerInsert#" index="totalRow">
	<br><br>INSERT #totalRow#<br>
	<cfloop from="1" to="#rowsPerInsert#" index="indRow">
		<cfset rowNumber = totalRow + indRow>
		<cfif rowNumber LTE totalRows>
			#rowNumber# #stRows[rowNumber]#
			<cfif indRow NEQ rowsPerInsert AND rowNumber NEQ totalRows> UNION ALL</cfif>
			<br>
		</cfif>
	</cfloop>
</cfloop>
</cfoutput>