 						<cfquery name="updateorig" datasource="uam_god">
 							#preserveSingleQuotes(sql)#
 						</cfquery>
+
+
+						<p>
+							#preserveSingleQuotes(sql)#
+						</p>
 						<cfset updatedOrig=true>
 				</cfif>
 			</cfloop>


		<cfloop query="d">
			<cftransaction>
				<cfif classification_id is '[NEW]'>
					<cfset thisClassificationID=CreateUUID()>
				<cfelse>
					<cfset thisClassificationID=classification_id>

	Magic tools

	<br><a href="processBulkloadClassification.cfm?action=fill_in_the_blanks_from_genus_nosource">fill_in_the_blanks_from_genus_nosource</a>
	<br><a href="processBulkloadClassification.cfm?action=get_data_from_genus_record">get_data_from_genus_record</a>

</p>
<!-------------------------------------------->
<cfif action is "get_data_from_genus_record">
	<cfoutput>

	<!--- after fill_in_the_blanks_from_genus_nosource; update seeded records to match genus ---->
	<cfquery name="d" datasource="uam_god">
		select distinct genus from CF_TEMP_CLASSIFICATION where scientific_name in (select scientific_name from CF_TEMP_CLASSIFICATION2)
	</cfquery>
	<!---- just a list for now.... ---->

<cfquery name="oClassTerms" datasource="uam_god">
		select
			taxon_term
		from
			CTTAXON_TERM
		where
			IS_CLASSIFICATION=1
		order by
			RELATIVE_POSITION desc
	</cfquery>



	<cfdump var=#oClassTerms#>

	<cfdump var=#d#>


	<cfloop query="d">
		<cfquery name="r" datasource="uam_god">
			select * from CF_TEMP_CLASSIFICATION where genus='#d.genus#' and species is null
		</cfquery>
		<p>
			<cfdump var=#r#>
		</p>
		<cfquery name="c" datasource="uam_god">
			select * from CF_TEMP_CLASSIFICATION where genus='#d.genus#' and species is not null
		</cfquery>

		<cfloop query="oClassTerms">
			<cfif taxon_term is "order">
				<cfset thistt="phylorder">
			<cfelse>
				<cfset thistt=taxon_term>
			</cfif>
			<cfset thisSrcData=evaluate("r." & thistt)>
			<cfif len(thisSrcData) gt 0>
				<p>
					update CF_TEMP_CLASSIFICATION set #thistt#='#thisSrcData#' where genus='#c.genus#' and #thistt# is null
				</p>
		<cfquery name="udt" datasource="uam_god">
			update CF_TEMP_CLASSIFICATION set #thistt#='#thisSrcData#' where genus='#c.genus#' and #thistt# is null
		</cfquery>

			<cfelse>
				<p>
					no #thistt# in source do nothing
				</p>
			</cfif>

		</cfloop>

	</cfloop>
	</cfoutput>

</cfif>
<!-------------------------------------------->
<cfif action is "fill_in_the_blanks_from_genus_nosource">

