 				<cfbreak>
 			</cfif>
 		</cfloop>
-		<!----
-
-		UAM@ARCTEST> desc ;
- Name								   Null?    Type
- ----------------------------------------------------------------- -------- --------------------------------------------
- STATUS 								    VARCHAR2(255)
- CLASSIFICATION_ID							    VARCHAR2(4000)
- USERNAME							   NOT NULL VARCHAR2(255)
- SOURCE 							   NOT NULL VARCHAR2(255)
- TAXON_NAME_ID								    NUMBER
- SCIENTIFIC_NAME						   NOT NULL VARCHAR2(255)
- AUTHOR_TEXT								    VARCHAR2(255)
- INFRASPECIFIC_AUTHOR							    VARCHAR2(255)
- NOMENCLATURAL_CODE						   NOT NULL VARCHAR2(255)
- SOURCE_AUTHORITY							    VARCHAR2(4000)
- VALID_CATALOG_TERM_FG							    VARCHAR2(255)
- TAXON_STATUS								    VARCHAR2(255)
- REMARK 								    VARCHAR2(255)
- DISPLAY_NAME								    VARCHAR2(255)
- SUPERKINGDOM								    VARCHAR2(255)
- KINGDOM								    VARCHAR2(255)
- SUBKINGDOM								    VARCHAR2(255)
- INFRAKINGDOM								    VARCHAR2(255)
- SUPERPHYLUM								    VARCHAR2(255)
- PHYLUM 								    VARCHAR2(255)
- SUBPHYLUM								    VARCHAR2(255)
- SUBDIVISION								    VARCHAR2(255)
- INFRAPHYLUM								    VARCHAR2(255)
- SUPERCLASS								    VARCHAR2(255)
- CLASS									    VARCHAR2(255)
- SUBCLASS								    VARCHAR2(255)
- INFRACLASS								    VARCHAR2(255)
- HYPERORDER								    VARCHAR2(255)
- SUPERORDER								    VARCHAR2(255)
- PHYLORDER								    VARCHAR2(255)
- SUBORDER								    VARCHAR2(255)
- INFRAORDER								    VARCHAR2(255)
- HYPORDER								    VARCHAR2(255)
- SUPERFAMILY								    VARCHAR2(255)
- FAMILY 								    VARCHAR2(255)
- SUBFAMILY								    VARCHAR2(255)
- SUPERTRIBE								    VARCHAR2(255)
- TRIBE									    VARCHAR2(255)
- SUBTRIBE								    VARCHAR2(255)
- GENUS									    VARCHAR2(255)
- SUBGENUS								    VARCHAR2(255)
- SPECIES								    VARCHAR2(255)
- SUBSPECIES								    VARCHAR2(255)
- SUBSP									    VARCHAR2(255)
- FORMA									    VARCHAR2(255)
----->
-<p>
-
 	<cfquery name="thisNoClass" datasource="uam_god">
 		select * from htax_noclassterm where tid=#variables.tid#
 	</cfquery>

create table cf_temp_classification_fh as select * from cf_temp_classification where 1=2;

 --->

<!---- data ---->
<cfquery name="d" datasource="uam_god">
	select * from hierarchical_taxonomy where status='ready_to_push_bl' and rownum < 500
</cfquery>
<!---- column names in order ---->
<cfquery name="CTTAXON_TERM" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
	select

				'#evaluate("variables." & i)#',
			</cfloop>
			'autoinsert_from_hierarchy',
			'#q.username#',
			'#dataset.source#',
			'#d.term#',
			'need NOMENCLATURAL_CODE'
		)
