 	select * from dgr_locator where freezer='1' and rack='1' and box='1'
 </cfquery>
 <cfoutput>
-
+<cftransaction>
 	<cfquery name="box" dbtype="query">
 		select freezer, rack, box from d group by freezer, rack, box
 	</cfquery>

				) values (
					#cid.id#,
					#lpid#,
					'cryovial,
					'NK #ist.nk# #ist.tissue_type#',
					'MSB',
					'autocreated from DGR Locator data'

			parent_container_id,
			container_type,
			label,
			institution_acronym,
			NUMBER_POSITIONS
		) values (
			#cid.id#,
			15300802,
			'freezer box',
			'DGR-#box.freezer#-#box.rack#-#box.box#',
			'MSB',
			100
		)
	</cfquery>
	<cfset boxid=cid.id>
