 </cfquery>
 <cfoutput>
 	<cfloop query="d">
-		<cfquery name="temp" datasource="uam_god">
-			select * from  temp_new_class_temp where 1=2
+		<cfset thisStatus=''>
+		<cfquery name="temp"dbtype="query">
+			select * from temp where 1=2
 		</cfquery>
+
+
 		<cfdump var=#temp#>
 		<cfset queryaddrow(temp,1)>
 

				<cfelse>
					<br>crap not hierarchical
					<cfset querysetcell(temp,"#thisTerm#",valuelist(thisDist.term,';'),1)>
				</cfif>
			</cfloop>
		</cfif>
		<cfquery name="nr" datasource="uam_god">
			insert into temp_new_class_temp (
			<cfloop list="#temp.columnlist#" index="t">

			</cfloop>
			)
		</cfquery>
		<cfdump var=#temp#>
		<cfquery name="g" datasource="uam_god">
			update temp_new_names_fd set status ='k' where scientific_name='#scientific_name#'
		</cfquery>
