 
 
 	<cfquery name="d" datasource="prod">
-		select * from temp_uwbm_agentmess where rawagnt1 is null
+		select * from temp_uwbm_allagent2 where rawagnt1 is null
 	</cfquery>
 	<cfoutput>
 		<cfloop query="d">
 			<cfset i=1>
 			<br>#agent#
 				<cfloop list="#agent#" index="a" delimiters=",;">
-					<!----
 					<cfquery name="u" datasource="prod">
-						update temp_uwbm_agentmess set rawagnt#i#='#a#' where agent='#d.agent#'
+						update temp_uwbm_allagent2 set rawagnt#i#='#a#' where agent='#d.agent#'
 					</cfquery>
-					---->
 
 					<br>-----#a#
 					<cfset i=i+1>

deal with UWBM mammal data from vertnet
maybe make this something else if if works

---->
<cfinclude template="/includes/_header.cfm">
<cfset title='vertnet hates me'>



		<cfquery name="d" datasource="prod">
			select distinct #f# rawstring from temp_uwbm_allagent2 where #f# is not null and
			#an# is null
		</cfquery>
		<cfloop query="d">
