 	order by
 		part_name
 </cfquery>
-<!---
-	now assemble part_ids in the order we want to see them
 ---->
-
 <cfquery name="orderedparts" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
  SELECT
  collection_object_id part_id,

		oc.parent_container_id=pc.container_id (+) and
		specimen_part.derived_from_cat_item=#one.collection_object_id#
</cfquery>
<cfquery name="parts" dbtype="query">
	select
		part_id,

 START WITH derived_from_cat_item=#one.collection_object_id#
 CONNECT BY PRIOR collection_object_id = SAMPLED_FROM_OBJ_ID
</cfquery>
<cfdump var=#orderedparts#>



<cfquery name="ploan" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
	SELECT
		loan.loan_number,
