 
 	select gotit,count(*) from temp_kwp_exp group by gotit;
 
---->
 <cfsetting requestTimeOut = "6000">
 <cfoutput>
 	<cfset  util = CreateObject("component","component.utilities")>

	</cfloop>

</cfoutput>

<!---- get taxonomy as list



create table temp_kwp_tax as select * from dlm.my_temp_cf;
alter table temp_kwp_tax add taxa varchar2(4000);


--->
<cfoutput>
		<cfquery name="d" datasource="uam_god">
			select * from temp_kwp_tax where taxa is null and rownum=1
		</cfquery>
		<cfloop query="d">
			<cfquery name="t" datasource="uam_god">
			select distinct FULL_TAXON_NAME from
			flat,
			specimen_part,
			coll_obj_cont_hist,
			container p,
			container t,
			container d,
			temp_kwp_tax
	where
		flat.collection_object_id=specimen_part.derived_from_cat_item and
		specimen_part.collection_object_id=coll_obj_cont_hist.collection_object_id and
		coll_obj_cont_hist.container_id=p.container_id and
		p.parent_container_id=t.container_id and
		t.parent_container_id=d.container_id and
		d.barcode=temp_kwp_tax.barcode
		</cfquery>
		<cfdump var=#t#>
		</cfloop>

</cfoutput>


<!----

	alter table temp_kwp_exp add cid number;
	update temp_kwp_exp set cid=(
		select
